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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access