When multiple users attempt to modify data at the same time Ex user 1 is updati

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

Question Posted / guest

4 Answers
10423 Views
Digital Group, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

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

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

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

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

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

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

Answer / gt

provide the transactionlevels

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

Is entity framework better than ado.net?

0 Answers

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

0 Answers

What is a serialized object?

0 Answers

What is the difference between a Dataset and DataReader? Can dataReader hold data from multiple tables?

3 Answers Fulcrum Logic, Merrill Lynch,

what is the syntax code for oldb to connect oracle

3 Answers IBM,

What is reference by value how does it works in .net?

2 Answers SQL Star,

What is difference between sqldatareader and sqldataadapter?

0 Answers

What providers does Ado.net uses?

0 Answers

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

0 Answers

Which control of the BindingNavigator returns the current position within the data source?

0 Answers

What are the steps to connect to a database?

0 Answers

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

0 Answers

For more ADO.NET Interview Questions Click Here