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 / kiranmadiraju

You can use one primary key and one timestamp field to sort
out the problem of concurrency.
The steps are like this
1.Fetch the record from database and store the primary key
value and timestamp in the session.
2.Update the same record with new values other fields using
the same session values for primary key and timestamp fields.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all components of ADO.Net data provider?

822


How to work with disconnected data - the dataset and sqldataadapter?

768


What is difference between Dataview and Datatable?

772


What you mean by filtering of data?

742


Which method is used to sort the data in ADO.Net?

1776


What is bubbled event?

753


What are dataproviders?

758


Explain the basic use of "dataview" and explain its methods.

741


Define the executescalar method?

709


What is connection in ado.net?

736


How do you update a dataset in ado.net and how do you update database through dataset?

722


What is difference between datagridview and datagrid control in winforms?

743


What are the core objects of ADO.NET?

811


Some important instruction regarding ADO.NET connection string ?

777


Name which operations can you not perform on an ado.net dataset?

744