O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

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

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 ...

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