Concurrency Control in ADO.NET

Concurrency control is the process used to identify and resolve updates to data that are made by multiple users simultaneously. The following topics explain common methods of concurrency control, as well as specific ADO.NET features for handling concurrency errors.

Introduction to Data Concurrency in ADO.NET

Provides an overview of the different methods of concurrency control.

How to: Handle Concurrency Errors

Describes how to use the DBConcurrencyException object to identify concurrency exceptions and the actual record that caused the error.

Walkthrough: Handling a Concurrency Exception

Provides step-by-step instructions for identifying and resolving a concurrency error.


Describes the DBConcurrencyException class and provides links to its members.

Optimistic Concurrency (ADO.NET)

Defines optimistic concurrency and the different approaches for implementing it.

Transactions and Concurrency (ADO.NET)

Details how to programmatically create and execute a data transaction.

Fetching Data into Your Application

Provides links to topics describing how to load data into datasets, and how to execute SQL statements and stored procedures.

Displaying Data on Forms in Windows Applications

Provides links to topics that explain how to display data on Windows Forms through data-bound controls.

Editing Data in Your Application

Provides links to topics describing how to manipulate the data in the data tables of a dataset.

Validating Data

Provides links to topics describing how to add validation to a dataset during column and row changes.

Saving Data

Provides links to topics explaining how to send updated data from an application to the database.

Community Additions