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

Get Sams Teach Yourself ADO.NET in 24 Hours 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.

Start your free trial