Lesson Summary

■ Transactions provide a way to maintain the integrity of your data by allowing a set of commands to be rolled back if one of them does not complete successfully.

■ Transactions are provider specific.

■ Transactions are created with the BeginTransaction method of a Connection object.

■ The availability of data (that is being modified by a transaction) can be controlled by setting the isolation level of a transaction.

■ Commands can be set to enlist in existing distributed transactions as well as in local transactions.

Was this article helpful?

0 0

Post a comment