IsolationLevel Enumeration

The IsolationLevel enumeration provides options for the SQL Server isolation level to be used.

Enumeration Values

Name	Summary
Unspecified	Specifies that the default transaction settings should be used from the parent.
Chaos	Specifies that there will be no restrictions on transactions.
ReadUncommitted	Specifies that rows that have not yet been committed as part of a write operation can be read. This isolation level permits dirty reads.
ReadCommitted	Specifies that only rows that have been fully committed as part of a write operation can be read. This isolation level prevents dirty reads, and it is the default isolation level.
RepeatableRead	Specifies that only rows that have been fully committed as part of a write operation can be read. It furthermore specifies that writes cannot occur on data that has been read by this transaction.
Serializable	Specifies the same constraints as RepeatableRead with the extra restriction that other transactions cannot insert key values that would be sorted into the same range of data that has been read by this transaction.
Snapshot	Specifies that all data visible to this transaction at the start of the transaction will be isolated in a separate snapshot that this transaction will operate on independently from other transactions. Changes from this transaction will be merged with changes from other transactions at the conclusion of the transaction.