Add tests for TransactionScope.Current

[madelson]

Add tests for presence of TransactionScope (Transaction.Current). In particular Postgres's transaction detection to avoid statement_timeout leaks and Multiplexing (what happens if the shared connection gets caught up in multiple transactions?). Seems like in Postgres this is a connection string option