Concurrency Management

The second check box, Use Optimistic Concurrency, determines how the wizard will create the Insert and Update SQL statements. ADO .NET does not fully rely on SQL Server (or other database system) record locking to implement concurrency. For those who may not be used to working in multiuser environments, concurrency is the way a database system handles conflicts between users. For example, user A reads some data. User B reads the same data. What happens when users A and B make changes and try to update the data at the same time? The way a database system handles these situations is called concurrency management. Most systems use some combination of row locking and row versioning to manage concurrency. Row locking is the ...

Get ADO.NET Programming in Visual Basic™ .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.