Enum IsolationLevel

    public enum IsolationLevel

Chaos	Specifies that there will be no restrictions on transactions.
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.
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.
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.
Unspecified	Specifies that the default transaction settings should be used from the parent.