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 dataset and datatable in ado.net?
Explain the overview of ado.net architecture?
What are the steps to connect to a database?
What are the steps you will take to improve performance?
How do you implement locking concept for dataset?
What is data relation?
What is the role of data provider in ado.net?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What are the difference between readonly vs. Const?
What is ole word?
Explain what is datagrid with an example?
How to creating a SqlCommand Object?
What is the role of clr?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
Explain all the classes those are used for database connections between sql server and asp.net?