IsolationLevel

Transaction isolation levels as defined by the SQL standard (plus vendor extensions).

Index

Enumeration Members

• READ_COMMITTED
• READ_UNCOMMITTED
• REPEATABLE_READ
• SERIALIZABLE
• SNAPSHOT

Enumeration Members

READ_COMMITTED

READ_COMMITTED: read committed

Prevents dirty reads; non-repeatable and phantom reads are still possible.

READ_UNCOMMITTED

READ_UNCOMMITTED: read uncommitted

Allows dirty reads, non-repeatable reads, and phantom reads.

REPEATABLE_READ

REPEATABLE_READ: repeatable read

Prevents dirty and non-repeatable reads; phantom reads are still possible.

SERIALIZABLE

SERIALIZABLE: serializable

Full isolation — transactions are executed as if they were run sequentially.

SNAPSHOT

SNAPSHOT: snapshot

Snapshot isolation — each transaction sees a consistent snapshot of the database (MSSQL).