Month: May 2007

Not Found

Apologies, but no results were found for the requested archive. Perhaps searching will help find a related post.

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

Posted on May 11, 2007 by sujatad

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… } }}

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> asp.net | Comments Off on Asp.net applications – data access in a database agnostic data way