An exe program is running on multiple clients. When you want to modify a table in the same database, how to prevent several people from modifying the same record of the same table at the same time?
In .net, open concurrency is generally used. When data is modified when it is submitted to the data source, the new data is compared with the old data by querying it. There are users who choose which data to save. Specific processing methods are given in <ado.net Technology Insider> or <ado.net Advanced Programming>.
update users where username = @ oldUserName and password = @ oldPassword
When performing such an update, if the number of affected rows is 0, the original record has been modified. This is optimistic concurrency.
|
|
China
Post time: 2020-1-15 14:20:01
Author