Performing General Tasks in ADO.NET 

In addition to connecting, retrieving, and modifying data, ADO.NET provides a variety of other features that can be used in the data access applications that you create. Some of these features include data tracing, consuming XML Web services, paging through query results, and more.

In This Section

• Managed Tracing in the .NET Framework
  Describes how ADO.NET provides new built-in data tracing functionality.

• Consuming a DataSet from an XML Web Service
  Describes how to create an XML Web service that uses a DataSet to transport data.

• Paging Through a Query Result
  Provides an example of viewing the results of a query as pages of data.

• Mapping Data Provider Data Types to .NET Framework Data Types
  Describes data type mappings between the ADO.NET data providers and the .NET Framework data types.

• Conserving Resources When Writing BLOB Values to SQL Server
  Describes how to conserve resources when writing binary large objects (BLOB) to SQL Server.

• Using Optimistic Concurrency
  Describes optimistic and pessimistic concurrency, and how you can test for concurrency violations.

Related Sections

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

• Modifying Data in ADO.NET
  Describes how to modify data in a database and how to use transactions.

• Connecting and Retrieving Data in ADO.NET
  Describes how to connect to a data source and retrieve data, including DataReaders and DataAdapters.

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

• Finding Additional ADO.NET Information
  Provides links to additional online information about ADO.NET.

See Also

Other Resources

ADO.NET