Treffer: Handling Data Concurrency Using ADO.NET.

Title:
Handling Data Concurrency Using ADO.NET.
Authors:
Source:
MSDN (1528-4859). Sep2004, Vol. 19 Issue 9, p21-25. 5p.
Database:
Supplemental Index

Weitere Informationen

This article explores how ADO.NET is equipped to detect and handle concurrency violations. It begins by discussing scenarios in which concurrency violations can occur using the ADO.NET disconnected model. Then it talks about ASP.NET application that handles concurrency violations by giving the user the choice to overwrite the changes or to refresh the out-of-sync data and begin editing again. Because part of managing an optimistic concurrency model can involve keeping a timestamp or another type of flag that indicates when a row was last updated, this article shows how to implement this type of flag and how to maintain its value after each database update.