This documentation is archived and is not being maintained.

Accessing Data with ADO.NET

ADO.NET is a set of classes that expose data access services to the .NET programmer. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers.

In This Section

Overview of ADO.NET
Provides an introduction to the design and components of ADO.NET.
Using .NET Framework Data Providers to Access Data
Describes the use of the Command, Connection, DataReader, and DataAdapter objects.
Creating and Using DataSets
Describes how to create and customize DataSet objects.
XML and the DataSet
Describes how the DataSet interacts with XML as a data source, including loading and persisting the contents of a DataSet as XML data.
Creating and Using DataTables
Describes how to create and customize DataTable objects.
Creating and Using DataViews
Describes how to create dynamic views of data in a DataTable, commonly used for data-binding applications.
Accessing an ADO Recordset or Record from ADO.NET
Describes how to populate a DataSet from an ADO Record or Recordset using the OleDbDataAdapter.
Sample ADO.NET Scenarios
Provides examples of common programming scenarios for data-aware applications, and solutions for these scenarios using ADO.NET.
Writing Secure ADO.NET Code
Describes secure coding practices when using ADO.NET.
Implementing a .NET Framework Data Provider
Describes how to create a custom .NET Framework data provider for your data store, and provides you with template code.

Related Sections

Building Applications
Provides instructive overviews and detailed, step-by-step procedures for creating applications in the .NET Framework.
Programming with the .NET Framework
Explains common programming tasks that apply to a range of .NET Framework applications. Topics include accessing data, extending metadata, handling and throwing exceptions, processing transactions, and securing applications.