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 / umar topia
Have one column with in Database table with datatype as
TimeStamp and while selecting the row we will read the
TimeStamp value, which we can compare at the time of updation,
if both values are same then we can update that row
otherwise we can resist the user from updating saying that
someone has updated the row, you can't update it.
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Which database is the ado.net sql connection object designed for?
What is ado.net tutorial?
What is ado net stands for?
What is a datagridview?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
Which object holds only data and does not interact with data source?
What is difference between ado.net and asp net?
What is disconnected data?
What are the connected and disconnected modes in ado.net?
Why do we use sqldataadapter?
What are the uses of Stored Procedure?
How many major types of connection objects in ADO.NET?
What are all the commands used with Data Adapter?
What is ambient transaction?
What are the advantages of oledb compared with other classes?