Asp.net applications – data access in a database agnostic data way

connectionString=”server=.;Initial Catalog=Northwind;…”
providerName=”System.Data.SqlClient”
/>

string databaseConnectionString =
ConfigurationManager.ConnectionStrings
[“DatabaseConnectionString”].connectionString;

string databaseProviderName =
ConfigurationManager.ConnectionStrings
[“DatabaseConnectionString”].ProviderName;

DbProviderFactory databaseProvider =
DbProviderFactories.GetFactory(databaseProviderName);

using (DbConnection dbConn = provider.CreateConnection())
{
dbConn.ConnectionString = connectionString
using (DbCommand command = dbConn.CreateCommand())
{
dbConn.Open();
using (DbDataReader dr = command.ExecuteReader())
{
// Do Something…
}
}
}