Code for opening two different database provider in one application at a time using Provider Model

<system.data>

    <DbProviderFactories>

      <remove invariant="MySql.Data.MySqlClient"></remove>

      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.8.3.0" />

      <remove invariant="System.Data.SqlServerCe.4.0" />

      <add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

    </DbProviderFactories>

  </system.data>

DbProviderFactory factory = DbProviderFactories.GetFactory(providerName);
connection = factory.CreateConnection();