SAIsolationLevel enumeration

Specifies SQL Anywhere isolation levels. This class augments the [external link] IsolationLevel.

Syntax

Visual Basic

Public Enum SAIsolationLevel

C#

public enum SAIsolationLevel

Remarks

The SQL Anywhere .NET Data Provider supports all SQL Anywhere isolation levels, including the snapshot isolation levels. To use snapshot isolation, specify one of SAIsolationLevel.Snapshot, SAIsolationLevel.ReadOnlySnapshot, or SAIsolationLevel.StatementSnapshot as the parameter to BeginTransaction. BeginTransaction has been overloaded so it can take either an IsolationLevel or an SAIsolationLevel. The values in the two enumerations are the same, except for ReadOnlySnapshot and StatementS napshot which exist only in SAIsolationLevel. There is a new property in SATransaction called SAIsolationLevel that gets the SAIsolationLevel.

For more information, see Snapshot isolation.

Members

Member name	Description	Value
Chaos	This isolation level is unsupported.	16
ReadCommitted	Sets the behavior to be equivalent to isolation level 1.	4096
ReadOnlySnapshot	For read-only statements, use a snapshot of committed data from the time when the first row is read from the database.	16777217
ReadUncommitted	Sets the behavior to be equivalent to isolation level 0.	256
RepeatableRead	Sets the behavior to be equivalent to isolation level 2.	65536
Serializable	Sets the behavior to be equivalent to isolation level 3.	1048576
Snapshot	Uses a snapshot of committed data from the time when the first row is read, inserted, updated, or deleted by the transaction.	16777216
StatementSnapshot	Use a snapshot of committed data from the time when the first row is read by the statement. Each statement within the transaction sees a snapshot of data from a different time.	16777218
Unspecified	This isolation level is unsupported.	-1

Discuss this page in DocCommentXchange.
Send feedback about this page using email.