Data Platform Developer Center > Learn > ADO.NET 1.1/2.0

ADO.NET 1.1/2.0

ADO.NET provides consistent access to data sources such as Microsoft SQL Server and XML, as well as to data sources exposed through OLE DB and ODBC. Learn more about the new and enhanced features available in ADO.NET 2.0.

Documentation

Articles

See the New Features in ADO.NET 2.0
ADO.NET 2.0 includes a new base-class provider model, enhancements to System.Data.SqlClient, and more. Get an overview of these new features and see examples of their use.

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.

Generic Coding with the ADO.NET 2.0 Base Classes and Factories
Learn more about the enhancements in ADO.NET 2.0 that enable you to create generic data access code.

Asynchronous Command Execution in ADO.NET 2.0
Get an overview of the new asynchronous execution functionality in ADO.NET 2.0, the scenarios it was developed to enable, plus some of the issues to keep in mind when using this feature.

Schemas in ADO.NET 2.0
Learn about the enhanced support in ADO.NET 2.0 for accessing metadata from your data sources.

Query Notifications in ADO.NET 2.0
See how the new notification technologies in ADO.NET 2.0 and SQL Server 2005 handle ad-hoc data refreshes.

XML Data Type Support in ADO.NET 2.0: Handling XML from SQL Server 2005
See how improvements to XML support in ADO.NET 2.0 and SQL Server 2005 work together to make handling XML data in your applications easier.

Tracing Data Access
Apply the tracing functionality in ADO.NET 2.0 and SQL Native Client to track down bugs and bottlenecks in your applications.

New DataSet Features in ADO.NET 2.0
Get performance enhancements and improved functionality in the .NET Framework 2.0 DataSet class, and in the closely related DataTable and DataView classes.