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 are the advantages of oledb compared with other classes?
How can we load multiple tables in to dataset?
What is ado full form?
Does sqlclient and oledb class share the same functionality?
Does dapper use ado.net?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What we do with the object of ado.net dataset after using it?
What is microsoft ado.net?
Which keyword is used to accept variable number of parameters?
What is ole access?
What are all the commands used with Data Adapter?
What is sqldatasource?
What does executequery return?
What is an ado?
Which object holds only data and does not interact with data source?