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

Related Sections

• Building ASP.NET Applications
  Provides instructive overviews and detailed, step-by-step procedures for creating ASP.NET Web applications in the .NET Framework.

• Windows-based Applications
  Provides detailed information about working with Windows Forms and console applications.

• Core Development Technologies
  Provides links to information about standard development tasks in the .NET Framework.

• Advanced Development Technologies
  Provides links to information on 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.