ADO.NET 3.5 Cookbook, 2nd Edition

Appendix A. What’s New in ADO.NET Since Version 1.0

ADO.NET is a set of classes that gives .NET applications access to relational, XML, and application data. The classes let you connect to data sources such as SQL Server and Oracle, as well as to data sources exposed through OLE DB and ODBC, and XML data. After you connect to these data sources, the ADO.NET classes let you retrieve, manipulate, and update data.

This appendix describes the new functionality, support, and features in ADO.NET since version 1.0.

A.1. ADO.NET 2.0

ADO.NET 2.0 was released as part of the release of .NET Framework 2.0. This section provides an overview of both new features in ADO.NET 2.0 and of significant changes and enhancements in ADO.NET 2.0 since ADO.NET 1.0.

Data Provider Enumeration and Factories

Data providers in ADO.NET 1.0 and 1.1 are a set of provider-specific classes that implement generic interfaces. These interfaces can be used to write code that is data provider-independent. For example, the data connection classes in the Microsoft SQL Server data provider (SqlConnection) and the Microsoft Oracle data provider (OracleConnection) both implement the IDbConnection interface. Code based on the IDbConnection interface that is common to both classes, rather than a database-specific instance of a data provider, is independent of the data provider and therefore not dependent on the underlying database. The disadvantage of the interface approach is that you cannot use the interface to access any database-specific ...