Protecting against transaction concurency (Transaction type; Transaction IsolationLevel)
- by Vytas999
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).