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
- 4 Answers
- 9805 Views
- Digital Group, I also Faced
- E-Mail Answers
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 do you mean by performing asynchronous operation using command object?
What are the main differences between classic ado and ado.net?
What is the use of ADO.NET and XML web services?
What is difference between ado.net and asp net?
What are the parameters that control most of connection pooling behaviours?
How to aggregating data across related tables?
Explain the architecture of ado.net?
What is row state?
What is the difference between Dataset. clone and Dataset.copy?
What is ado.net in vb net?
What is the executescalar method?
Explain the difference between data reader and data set?
Which database is the ado.net sql connection object designed for?
Which is the best method to get two values from the database?
Which namespaces are used for data access?
