Programming Microsoft® SQL Server® 2012

Conventional ADO.NET

We’ve already defined conventional ADO.NET as the two available data access options that were introduced with .NET 1.0; namely, the raw data access objects and the DataSet/DataAdapter abstraction over those objects. You’ll now explore both of these approaches, beginning with the raw objects.

Using the Raw Data Access Objects

The raw ADO.NET data access objects are based on the following set of interfaces in the .NET Framework, which are defined in the System.Data namespace:

• IDbConnection

• IDbCommand

• IDbParameter

• IDbDataReader

• IDbTransaction

These interfaces define the operations that can be conducted against the database (or other back-end data source) by any concrete provider that implements them. For SQL Server, there is a managed ...