Protecting against transaction concurency (Transaction type; Transaction IsolationLevel)

Posted by Vytas999 on Stack Overflow See other posts from Stack Overflow or by Vytas999
Published on 2010-03-31T08:43:53Z Indexed on 2010/03/31 9:03 UTC
Read the original article Hit count: 521

Filed under:
|
|

Middle-tier component will execute the data access routines in application. The component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction. The code for the middle-tier will implement the following objects:

SqlCommand comm = connection.CreateCommand();
SqlTransaction trans;

How i must add code to component to specify the highest possible level of protection against such errors(two users try to update the same data concurrently).

© Stack Overflow or respective owner

Related posts about sql

Related posts about transaction