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 we do with the object of ado.net dataset after using it?
What is row state?
How to create dynamic gridview?
If we are not returning any records from the database, which method is to be used?
Explain the difference in an abstract class and an interface?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
Explain the different row versions available in table?
What are the features of ado.net?
Is datareader faster than datatable?
How do you implement locking concept for dataset?
Which control of the BindingNavigator returns the current position within the data source?
Define partial class?
How to load multiple tables into a dataset?
What is a dataview?
Explain the dataadapter class in ado.net?