Understanding Transaction in ADO.NET
page 3 of 8
Average Rating: 
Views (Total / Last 10 Days): 48515/ 103

When To Use Transactions

We should use transaction when several operations must succeed or fail as a unit.

The following are some frequent scenarios when we must use transactions:

1.  when multiple rows must be inserted or deleted or updated as a single unit

2. whenever a change to one table requires other tables to be updated

3. when modification of data is required in two or more databases, concurrently

4. where data is modified in databases in a different server

View Entire Article

User Comments

No comments posted yet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2022 ASPAlliance.com  |  Page Processed at 2022-05-16 1:07:48 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search