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
differance between ADO vs ADO.Net?
What is the difference between Data adaptor and Data set?
What are the benefits of using of ADO.NET in .NET 4.0?
What are the disadvantages of using datalist?
Describe the disconnected architecture of ADO.NET’s data access model.
What are the namespaces used in ADO.Net to connect to a database?
What is the difference between OLEDB Provider and SqlClient?
Which provider is used to connect ms access, oracle, etc…?
What are the advantage of ado.net?
What are the namespaces used in ado.net for data access?
What are the classes in System.Data.Common Namespace?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is execute scalar in ado.net?
What is the difference in an abstract class and an interface?