Allows setting an IsolationLevel when starting a new transaction. The underlying databases validate what levels of the ANSI + Snapshot levels are appropriate. Additionally, some databases require SET of the isolation level before a BEGIN of a transaction.
Functional testing is thin, because it's hard to validate the isolation levels without either:
Setting up dedicated scenarios for all databases to test.
Checking that the connection executed the SET statement correctly.
Somehow checking that the isolation level of the connection changed. Difficulty greatly depends on the database provider here. It's unclear if this is feasible for all providers.
Allows setting an
IsolationLevelwhen starting a new transaction. The underlying databases validate what levels of the ANSI + Snapshot levels are appropriate. Additionally, some databases requireSETof the isolation level before aBEGINof a transaction.Functional testing is thin, because it's hard to validate the isolation levels without either:
SETstatement correctly.