Create Provider-Independent Data Access Code with ADO.NET 2.0

Thursday Sep 1st 2005 by DatabaseJournal.com Staff
Share:

ADO.NET 2.0 offers new base classes and factory classes that enable you to write data access code that works with almost all data stores. Find out how to seamlessly working with multiple providers like SqlClient, OleDb, and ODBC without having to lock into a specific implementation.

[From Developer.com]

One of the new features of ADO.NET 2.0 is the ability to create provider-independent data access code that enables you to code against a set of base abstract classes without referencing provider-specific classes. The key advantage of this approach is that it gives you the option of seamlessly working with multiple providers like SqlClient, OleDb, and ODBC without having to lock into a specific implementation. To this end, ADO.NET 2.0 provides a new namespace named System.Data.Common that exposes a number of base classes and factory classes.

This article focuses on these base classes and factory classes of this namespace and shows examples of how to leverage them to create provider-independent data access code in an ASP.NET application.

The article continues at http://www.developer.com/net/net/article.php/3530396

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved