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


Please Help Members By Posting Answers For Below Questions

Define data adapter?

713


What are basic methods of dataadapter?

726


What is meant by executenonquery?

734


Which namespaces are used for data access?

874


Define Execute Scalar?

769


What are the different methods by which we can populate a dataset?

963


What is partial class?

746


Some important instruction regarding ADO.NET connection string ?

768


What are the core objects of ADO.NET?

801


What is the difference in an abstract class and an interface?

746


What is the role of data provider in ado.net?

758


Which is the feature of ado.net?

765


Explain how can we load multiple tables in to dataset?

715


Explain how to find the given query is optimised one or not?

727


How to aggregating data across related tables?

789