Understanding Transaction in ADO.NET
page 3 of 8
by SANJIT SIL
Feedback
Average Rating: 
Views (Total / Last 10 Days): 48443/ 98

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-2021 ASPAlliance.com  |  Page Processed at 2021-11-29 12:35:03 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search