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.

In This Section

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

Reference

• DBConcurrencyException
  Describes the DBConcurrencyException class and provides links to its members.

Related Sections

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