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
What is Data Provider?
Explain the basic use of "dataview" and explain its methods.
Explain the namespaces in which .net has the data functionality class.
What do you know about ado.net's methods?
How to pass multiple tables in datasets simultaneously?
How to find the given query is optimised one or not?
What is ado.net tutorial?
What is dataset and datatable in ado.net?
What are the Features of a dataset
How to identify the updated rows in a dataset?
How to maintain the relation between two tables in ADO.NET?
What is connection in ado.net?
What connected data?
What is ado in agriculture?
What is ado.net in mvc?