ADO.NET is Microsoft's platform for data access in the .NET Framework. Out of the box, ADO.NET is scalable, interoperable, and familiar enough to ADO developers to be immediately usable. By design, the ADO.NET object model and many of the ADO.NET code constructs will look very familiar to ADO developers.

At the most basic level, ADO.NET consists of the following set of framework namespaces:

  • System.Data

  • System.Data.Common

  • System.Data.SqlClient

  • System.Data.OleDbClient

  • System.Data.SqlTypes

The System.Data namespace contains many of the objects on which ADO.NET is built. This is where you'll find the DataTable, DataSet, DataRelation, and DataView objects. Additionally, this is where ADO.NET constants are stored. For instance, the System.Data.SqlDbType ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.