TransactionIsolationLevel Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Enumerates the set of possible isolation levels for a Transaction.
public enum TransactionIsolationLeveltype TransactionIsolationLevel = Public Enum TransactionIsolationLevel- Inheritance
-
TransactionIsolationLevel
Fields
| Name | Value | Description |
|---|---|---|
| Default | 0 | Indicates the default isolation level of the store. |
| ReadUncommitted | 1 | Indicates that volatile data can be read during the transaction. |
| ReadCommitted | 2 | Indicates that volatile data cannot be read during the transaction, but can be modified. Shared locks are held while data is being read to avoid dirty reads, but data can be changed before the end of the transaction that results in non-repeatable reads or phantom data. |
| RepeatableRead | 3 | Indicates that volatile data can be read but not modified during the transaction. Locks are placed on all data that is used in a query to prevent other users from updating data. New rows can be inserted into data sets and are included in later reads in the current transaction. |
| Snapshot | 4 | Indicates the snapshot level where volatile data can be read. Any data that is read will be a transaction-consistent version of the data that existed at start of the transaction. |
| Serializable | 5 | Indicates that volatile data are serializable. Volatile data can be read but not modified, and no new data can be added during the transaction. Indicates that range locks will be put on data sets. The locks prevent updates or inserts in data sets until the transaction finishes. |
