How Do I...Use explicit transactions in my application?

If you want to explicitly create a transaction, use the CommittableTransaction class instead of the TransactionScope class. There are important differences between CommittableTransaction objects and TransactionScope objects:

• Creating a CommittableTransaction does not set the current transaction. This means a transacted resource you might perform an action on will not automatically be part of the current transaction. You will need to manually pass the transaction you created to the transacted resource.
• When using CommittableTransactions, you must call commit or rollback.
• Exceptions do not automatically rollback transactions. Rollback must be called manually if a failure occurred when an exception is thrown.

1. In it's simplest form, create a new CommittableTransaction CommittableTransaction tx = new CommittableTransaction(); Dim tx As New CommittableTransaction()

2. To commit the transaction, call the commit method tx.Commit(); tx.Commit()

3. Or to rollback the transaction, call the rollback method tx.Rollback(); tx.Rollback()

Here is a full example: