O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Provider Factory Model

ADO.NET 2.0 introduces a provider factory model, as well as common base classes (DbConnection, DbCommand, and so on) for the various ADO.NET classes. Before we take a closer look at the new features, let’s take a brief look at why the interfaces (IDbConnection, IDbCommand, and so on) that were already available in ADO.NET version 1.0 left room for improvement.

Limitations of the ADO.NET Common Interfaces

Each Connection class (SqlConnection, OracleConnection, and so on) in the initial releases of ADO.NET implemented a common interface—IDbConnection. You could cast any Connection class to the IDbConnection interface and perform common tasks (such as setting the ConnectionString property or opening or closing the connection ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required