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.