Hour 18. Working with Transactions

for RuBoard

Hour 18. Working with Transactions

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

for RuBoard