Transactions

[zspitz]

1. If an SQL statement should be executed on a specific transaction, where should it go in the argument list?
2. Do we need to check that the transaction and connection match? both that their types match, and that the transaction is on the given connection?

Probably have an overload that takes a ref IDbTransaction, and if the argument is null, begin a new transaction.

Transaction rollback / commit is left up to the calling code.

What about TransactionScope?