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

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

716


Define the data provider classes that is supported by ado.net?

642


Which object holds only data and does not interact with data source?

626


Does executenonquery return a value?

652


How to copy the contents from one table to another table and how to delete the source table in ado.net?

660






What are the different methods available under the sqlcommand class to access the data?

694


What is aggregate root?

625


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

658


What is Data Provider?

716


What is a string variable?

602


What is difference between ado and other data object?

585


can we create synonymn in ms access,sql server,my sql if so explain me with example

1716


What is the maximum pool size in ado.net connection string?

611


How to pass multiple tables in datasets simultaneously?

707


What does ole stand for in excel?

760