TransactionIsolationLevel Enumeration

 

Specifies the value of the TransactionAttribute.

Namespace:   System.EnterpriseServices
Assembly:  System.EnterpriseServices (in System.EnterpriseServices.dll)

[<SerializableAttribute>]
type TransactionIsolationLevel

Member nameDescription
Any

The isolation level for the component is obtained from the calling component's isolation level. If this is the root component, the isolation level used is Serializable.

ReadCommitted

Shared locks are held while the data is being read to avoid reading modified data, but the data can be changed before the end of the transaction, resulting in non-repeatable reads or phantom data.

ReadUncommitted

Shared locks are issued and no exclusive locks are honored.

RepeatableRead

Locks 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.

Serializable

Prevents updating or inserting until the transaction is complete.

The following code example demonstrates the use of the TransactionIsolationLevel type.

No code example is currently available or this language may not be supported.

.NET Framework
Available since 1.1
Return to top
Show: