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, 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.
- Overview of ADO.NET
Provides an introduction to the design and components of ADO.NET.
- Securing ADO.NET Applications
Describes secure coding practices when using ADO.NET.
- Using DataSets in ADO.NET
Describes how to create and use DataSets, typed DataSets, DataTables, and DataViews.
- Connecting and Retrieving Data in ADO.NET
Describes how to connect to a data source and retrieve data, including DataReaders and DataAdapters.
- Modifying Data in ADO.NET
Describes how to modify data in a database and how to use transactions.
- Using the .NET Framework Data Provider for SQL Server
Describes how to work with features and functionality that are specific to SQL Server.
- Using the .NET Framework Data Provider for Oracle
Describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.
- Using SQL Server Common Language Runtime Integration
Describes how data can be accessed from within a common language runtime (CLR) database object in SQL Server 2005.
- Writing Provider Independent Code in ADO.NET
Describes generic classes that allow you to write provider-independent code in ADO.NET.
- Performing General Tasks in ADO.NET
Describes how to use various general-purpose features of ADO.NET.
- Finding Additional ADO.NET Information
Provides links to additional online information about ADO.NET.