O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required