Essential ADO.NET

5.1. Optimistic Concurrency

Chapter 4 explores the DataSet type and explains how this type lets you manage multiple tables using relational structures and constraints in memory. Although DataSet can be used as a standalone class, one of its uses is to facilitate using disconnected updates with other data sources such as databases. Disconnected fetching and updating use the classes described in the connected model in Chapter 3.

In general, updates to databases consist of inserts, updates, and deletes of individual rows or sets of rows. They can usually be done in three ways:

• Discrete SQL or other command statements are executed.

• A row is retrieved from the database and presented to the user for updating. That user has exclusive access to the row ...