DatasourceIsolation 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.
Controls the locking behavior of the SQL statements when executing commands against the data source.
public enum DatasourceIsolationtype DatasourceIsolation = Public Enum DatasourceIsolation- Inheritance
-
DatasourceIsolation
Fields
| Name | Value | Description |
|---|---|---|
| ReadCommitted | 1 | Specifies that statements cannot read data that has been modified, but not committed, by other transactions. This prevents dirty reads. |
| Snapshot | 2 | Specifies that the data read by any statement in a transaction is transactionally consistent, as if the statements in a transaction receive a snapshot of the committed data as it existed at the start of the transaction. |