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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / shweta
we can have to use exclusive locks on the table thats why
we can't change data at a time..
| Is This Answer Correct ? | 3 Yes | 1 No |
What is difference between datareader and dataadapter?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What are major difference between classic ADO and ADO.NET?
Which property is used to check whether a DataReader is closed or opened?
differance between ADO vs ADO.Net?
How many types of data table are in SQL.NET
4 Answers Chetu India, HCL, MAHINDRA,
What are the attirbutes of DataSet?
What is the provider being used to access oracle database?
Diff. b/w DataReader and DataSet?
What is ado.net and its features?
Why sql Data Reader object not created
How to sort the data in Datatable
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)