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 XML serialization
How to bind the controls(best practice) comboboxes to the data in the dataset?
Explain the difference between data reader and data set?
Explain the dataadapter class in ado.net?
What is ado or jdbc?
Can we load multiple tables in a dataset?
What are the connected and disconnected modes in ado.net?
Explain executenonquery?
What is the default provider in ado.net?
What are two types of transaction supported by ado.net?
Do we use stored procedure in ADO.Net?
Can datareader hold data from multiple tables?
How to generate a single aggregate?
Which architecture does Datasets follow?
What is connected architecture in ado.net?