■ 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?