Explicitly set TransactionIsolation as TRANSACTION_READ_COMMITTED.