Chapter 5. Transaction Processing in ADO.NET

After completing this chapter, you will be able to:

  • Create a Transaction.

  • Create a Nested Transaction.

  • Commit a Transaction.

  • Roll back a Transaction.

In the last few chapters, we've seen how Microsoft ADO.NET Data Provider objects interact in the process of editing and updating data. In this chapter, we'll complete our examination of ADO.NET Data Providers with an exploration of transaction processing.

Understanding Transactions

A transaction is a series of actions that must be treated as a single unit of work—either all the actions succeed, or they all fail. The classic example of a transaction is the transfer of funds from one bank account to another. To transfer an amount of, say, $100, the funds are withdrawn ...

Get Microsoft® ADO.NET 2.0 Step by Step, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.