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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is aggregate root?

494


Can we do database operations without using any of the ado.net objects?

535


What are three methods for displaying data in a syncfusion datagrid

612


how we can fire event in databound coulm in datagfrid withot using button?

567


Is it possible to edit data in Repeater control?

529






What is ado full form?

504


What is microsoft ado?

513


What is the difference between ado.net and entity framework?

506


What is dao and ado?

480


Explain the advantages and disadvantages of using datalist?

614


How do you merge 2 datasets into the third dataset in a simple manner?

535


Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

590


What is an ADO.Net?

566


Does ado.net use odbc?

521


What is the difference between oledb sql server and oledbdotnet provider?

500