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
- 4 Answers
- 9876 Views
- Digital Group, I also Faced
- E-Mail Answers
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
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What are the 3 major types of connection objects in ado.net?
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
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?
What is ado.net architecture?
What are the namespaces used in ado.net for data access?
What is execute scalar in ado.net?
Can datareader hold data from multiple tables?
What are the steps you will take to improve performance?
Explain how can we load multiple tables in to dataset?
What are the data providers used in ado.net
Does dapper use ado.net?
How can we add/remove row's in "datatable" object of "dataset"?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
