DataSourceIsolation DataSourceIsolation DataSourceIsolation Enum

Definition

Controls the locking behavior of the SQL statements issued to a data source.

public enum class DataSourceIsolation
public enum DataSourceIsolation
Public Enum DataSourceIsolation
Inheritance
DataSourceIsolationDataSourceIsolationDataSourceIsolation

Fields

ReadCommitted ReadCommitted ReadCommitted 0

Specifies that statements cannot read data that has been modified, but not committed, by other transactions. This prevents dirty reads.

Snapshot Snapshot Snapshot 1

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.

Remarks

New: 17 July 2006

Snapshot is data source dependant.

Applies to