In the preceding hour, you saw how to use SQL and OLE DB connection pooling in your applications to increase your application's responsiveness and decrease the amount of system resources used. In this hour, you're going to see how database transactions can help maintain the integrity of your database. A transaction is a set of actions that are executed as a group , with all actions succeeding or all actions failing.
In this hour, you'll see how to
Initiate a database transaction using ADO.NET
Roll back changes made to a database
Save changes made while using a transaction
Perform a database transaction in a stored procedure