Retrieving and Modifying Data in ADO.NET


A primary function of any database application is connecting to a data source and retrieving the data that it contains. The .NET Framework data providers of ADO.NET serve as a bridge between an application and a data source, allowing you to execute commands as well as to retrieve data by using a DataReader or a DataAdapter. A key function of any database application is the ability to update the data that is stored in the database. In ADO.NET, updating data involves using the DataAdapter and DataSet, and Command objects; and it may also involve using transactions.

In This Section

Connecting to a Data Source in ADO.NET

Describes how to establish a connection to a data source and how to work with connection events.

Connection Strings in ADO.NET

Contains topics describing various aspects of using connection strings, including connection string keywords, security info, and storing and retrieving them.

Connection Pooling

Describes connection pooling for the .NET Framework data providers.

Commands and Parameters

Contains topics describing how to create commands and command builders, configure parameters, and how to execute commands to retrieve and modify data.

DataAdapters and DataReaders

Contains topics describing DataReaders, DataAdapters, parameters, handling DataAdapter events and performing batch operations.

Transactions and Concurrency

Contains topics describing how to perform local transactions, distributed transactions, and work with optimistic concurrency.

Retrieving Identity or Autonumber Values

Provides an example of mapping the values generated for an identity column in a SQL Server table or for an Autonumber field in a Microsoft Access table, to a column of an inserted row in a table. Discusses merging identity values in a DataTable.

Retrieving Binary Data 

Describes how to retrieve binary data or large data structures using CommandBehavior.SequentialAccess to modify the default behavior of a DataReader.

Modifying Data with Stored Procedures

Describes how to use stored procedure input parameters and output parameters to insert a row in a database, returning a new identity value.

Retrieving Database Schema Information

Describes how to obtain available databases or catalogs, tables and views in a database, constraints that exist for tables, and other schema information from a data source.


Describes the provider factory model and demonstrates how to use the base classes in the System.Data.Common namespace.

Data Tracing in ADO.NET

Describes how ADO.NET provides built-in data tracing functionality.

Performance Counters in ADO.NET

Describes performance counters available for SqlClient and OracleClient.

Asynchronous Programming

Describes ADO.NET support for asynchronous programming.

SqlClient Streaming Support

Discusses how to write applications that stream data from SQL Server without having it fully loaded in memory.