ConnectionOptions.IsolationLevel Property
Specifies the isolation level for all queries, stored procedures, and other operations executed for the specified connection.
Namespace: DevExpress.DataAccess.Sql
Assembly: DevExpress.DataAccess.v23.2.dll
NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap
Declaration
[DefaultValue(SqlIsolationLevel.None)]
public SqlIsolationLevel IsolationLevel { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| SqlIsolationLevel | None | The isolation level. |
Available values:
| Name | Description |
|---|---|
| None | The default isolation level of the database management system is used. |
| ReadUncommitted | A transaction retrieves data that has been modified but not committed by other transactions. |
| ReadCommitted | Transaction statements cannot read data that has been modified but not committed by other transactions. |
| RepeatableRead | Transaction statements cannot read data that has been modified but not yet committed by other transactions. Other transactions cannot modify data that has been read by the current transaction until the current transaction is completed. |
| Serializable | A transaction retrieves exactly the same data every time it repeats a read operation. |
| Snapshot | Specifies that data read by any statement in a transaction will be the transactionally consistent version of data that existed at the start of the transaction. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to IsolationLevel |
|---|---|
| SqlDataSource |
|
Remarks
Use the SqlQuery.IsolationLevel property to set the isolation level for the connection of the specified query.
SqlQuery.IsolationLevel has priority over ConnectionOptions.IsolationLevel.