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 is fill method in ado.net?
Explain the difference between ado and ado.net?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
Which ado.net object is very fast in getting data from the database?
What is the difference between sqldatareader and sqldataadapter?
describe the dataset object in ado.net.
What is bubbled event?
Define Execute Scalar?
What are the advantages using ado.net?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What are advantages of microsoft-provided data provider classes in ado.net?
What are the core objects of ADO.NET?
What are dataproviders?
What is microsoft ado?
differance between ADO vs ADO.Net?