Commands associated with a transaction object are executed as a single transaction. The transaction is terminated with a call
to the Commit or Rollback methods.
To associate a command with a transaction object, use the SACommand.Transaction property.