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