DB Operations in asp.net with c#

Question

I have a question from an interviewer:

If two users open the same page, one person adding 105 record and another person deleting the same record, what happens in this scenario?

How do I answer this?

I think, it should 1 person editing record and on the other side anohter person deleting record and when 1 person try to update and it would not.. — Muhammad Akhtar
– Muhammad Akhtar, Commented Dec 1, 2009 at 5:32

Kyle Rosendo · Accepted Answer · 2009-12-01 05:30:54Z

2

That's a bit odd, as the records would not be there yet to delete if this was simultaneous access. Anywho, I am sure they are looking at Concurrency, and probably Optimistic Concurrency.

Have a look at this page, showing how to implement Optimistic Concurrency with ASP.NET.

answered Dec 1, 2009 at 5:30

Kyle Rosendo

25.3k8 gold badges83 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RickNZ · Accepted Answer · 2011-12-02 03:06:45Z

0

Potential conflicts are resolved in two places. First, on the web tier, using locking to make sure that each request is looking at consistent data.

Second, at the database tier, using transactions.

answered Dec 2, 2011 at 3:06

RickNZ

18.7k3 gold badges55 silver badges67 bronze badges

Collectives™ on Stack Overflow

DB Operations in asp.net with c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related