ADO.NET is a set of classes that expose data access services for .NET Framework programmers. 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, 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

What's New in ADO.NET

Introduces features that are new in ADO.NET.

ADO.NET Overview

Provides an introduction to the design and components of ADO.NET.

Entity Framework

Describes how to create applications using the Entity Framework.

Securing ADO.NET Applications

Describes secure coding practices when using ADO.NET.

Data Type Mappings in ADO.NET 

Describes data type mappings between .NET Framework data types and the .NET Framework data providers.

DataSets, DataTables, and DataViews

Describes how to create and use DataSets, typed DataSets, DataTables, and DataViews.

LINQ to DataSet 

Provides information about LINQ to DataSet, including programming examples.

Retrieving and Modifying Data in ADO.NET

Describes how to connect to a data source and how to retrieve and modify data using Commands, DataReaders and DataAdapters.

SQL Server and ADO.NET

Describes how to work with features and functionality that are specific to SQL Server.

Oracle and ADO.NET

Describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.

Related Sections

PAVE Security in Native and .NET Framework Code  

Provides links to security topics for Visual Studio, the .NET Framework, and cryptography.

LINQ (Language-Integrated Query) 

Provides links to LINQ topics and samples.

WCF Data Services 4.5  

Describes how to use WCF Data Services to deploy data services on the Web or an intranet that implement the Open Data Protocol (OData).

Core Development Technologies 

Provides links to information about standard development tasks in the .NET Framework.

Advanced Development Technologies

Provides links to information about sophisticated development tasks and techniques in the .NET Framework.

Samples and Quickstarts

Provides complete listings of all samples and QuickStart samples associated with the .NET Framework.