Export (0) Print
Expand All
Expand Minimize
2 out of 8 rated this helpful - Rate this topic

IsolationLevel Enumeration

Specifies the transaction locking behavior for the connection.

Namespace: System.Data
Assembly: System.Data (in system.data.dll)

public enum class IsolationLevel
public enum IsolationLevel
public enum IsolationLevel
 Member nameDescription
Supported by the .NET Compact FrameworkChaosThe pending changes from more highly isolated transactions cannot be overwritten. 
Supported by the .NET Compact FrameworkReadCommittedShared 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. 
Supported by the .NET Compact FrameworkReadUncommittedA dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored. 
Supported by the .NET Compact FrameworkRepeatableReadLocks 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. 
Supported by the .NET Compact FrameworkSerializableA range lock is placed on the DataSet, preventing other users from updating or inserting rows into the dataset until the transaction is complete. 
Supported by the .NET Compact FrameworkSnapshotReduces 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. 
Supported by the .NET Compact FrameworkUnspecifiedA different isolation level than the one specified is being used, but the level cannot be determined. 

When using OdbcTransaction, if you do not set IsolationLevel or you set IsolationLevel to Unspecied, the transaction executes according to the default isolation level of the underlying ODBC driver.

The IsolationLevel values are used by a .NET Framework data provider when performing a transaction.

The IsolationLevel remains in effect until explicitly changed, but it can be changed at any time. The new value is used at execution time, not parse time. If changed during a transaction, the expected behavior of the server is to apply the new locking level to all statements remaining.

Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.