When multiple users attempt to modify data at the same time
Ex user 1 is updating record at same time user2 deleted
record sucessfully.now user1 has press update button . how
to handle concurrency
Answer Posted / kiranmadiraju
You can use one primary key and one timestamp field to sort
out the problem of concurrency.
The steps are like this
1.Fetch the record from database and store the primary key
value and timestamp in the session.
2.Update the same record with new values other fields using
the same session values for primary key and timestamp fields.
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are all components of ADO.Net data provider?
How to work with disconnected data - the dataset and sqldataadapter?
What is difference between Dataview and Datatable?
What you mean by filtering of data?
Which method is used to sort the data in ADO.Net?
What is bubbled event?
What are dataproviders?
Explain the basic use of "dataview" and explain its methods.
Define the executescalar method?
What is connection in ado.net?
How do you update a dataset in ado.net and how do you update database through dataset?
What is difference between datagridview and datagrid control in winforms?
What are the core objects of ADO.NET?
Some important instruction regarding ADO.NET connection string ?
Name which operations can you not perform on an ado.net dataset?