O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Q&A

Q1: Is it wrong to create an explicit transaction (Begin Trans/Commit Trans) in .NET?
A1: No, not at all. This is pessimistic concurrency and it just won't scale as well as optimistic concurrency. However, it might be what your .NET application requires.
Q2:What type of applications should I be using optimistic concurrency with?
A2: Using an optimistic concurrency approach is highly successful when the application's data has minimal contention situations (when the application's users rarely work on the same data at the same time) and when there is a high volume of users—very optimal for Web applications.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required