ADO.NET

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.

• 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 (ADO.NET)
  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.

• ADO.NET Entity Framework
  Describes how to create applications using the Entity Framework.

• Entity Data Model Tools
  Describes how to use the Entity Data Model Tools, which are provided by the Entity Framework, to create applications.

• ADO.NET Data Services Framework
  Describes how to use the ADO.NET Data Services framework to deploy data services on the Web or an intranet.

• 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

• Security in Native and .NET Framework Code
  Provides links to security topics for Visual Studio, the .NET Framework, and cryptography.

• Language-Integrated Query (LINQ)
  Provides links to LINQ topics and samples.

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

See Also

Other Resources

Accessing Data (Visual Studio)

ADO.NET 3.5 Cookbook, Second Edition

Programming Entity Framework: Building Data Centric Apps with the ADO.NET Entity Framework

Programming Visual Basic 2008: Build .NET 3.5 Applications with Microsoft's RAD Tool for Business