SqlServerIsolationLevel Enumeration
Specifies isolation level for the operation.
Namespace:
Tortuga.ChainAssembly: Tortuga.Chain.SqlServer.MDS (in Tortuga.Chain.SqlServer.MDS.dll)
Members
| Member name | Description | |
|---|---|---|
| ReadUncommitted | A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored. | |
| ReadCommitted | Shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in non-repeatable reads or phantom data. | |
| RepeatableRead | Locks are placed on all data that is used in a query, preventing other users from updating the data. Prevents non-repeatable reads but phantom rows are still possible. | |
| Serializable | A range lock is placed on the System.Data.DataSet, preventing other users from updating or inserting rows into the dataset until the transaction is complete. | |
| Snapshot | Reduces blocking by storing a version of data that one application can read while another is modifying the same data. Indicates that from one transaction you cannot see changes made in other transactions, even if you requery. |