ADO.NET Namespaces

The root namespace for working with data in the .NET Framework is System.Data. This namespace provides the DataSet and DataTable objects you'll use to work with any type of data. In addition, the .NET Framework provides two specific namespaces that each provides objects for retrieving data that you'll learn about in this book:

  • System.Data.OleDb. Used for working with any OLE DB data source, such as Jet, Oracle, and so on. This namespace supports existing unmanaged (that is, with code written outside the CLR) ADO providers. This namespace includes the OleDbConnection, OleDbCommand, OleDbDataReader, and OleDbDataAdapter objects.

  • System.Data.SqlClient. Provides direct support for SQL Server 6.5 and later, using a managed provider. ...

Get ASP.NET Developer's JumpStart 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.