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
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?
Define the data provider classes that is supported by ado.net?
Which object holds only data and does not interact with data source?
Does executenonquery return a value?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What are the different methods available under the sqlcommand class to access the data?
What is aggregate root?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What is Data Provider?
What is a string variable?
What is difference between ado and other data object?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What is the maximum pool size in ado.net connection string?
How to pass multiple tables in datasets simultaneously?
What does ole stand for in excel?