'Declaration
 
Public Overridable Function ApplicableIsolationLevel( _
   ByVal level As IsolationLevel _
) As IsolationLevel

'Usage
 
Dim instance As DataSyntax
Dim level As IsolationLevel
Dim value As IsolationLevel
 
value = instance.ApplicableIsolationLevel(level)

public virtual IsolationLevel ApplicableIsolationLevel( 
   IsolationLevel level
)

Parameters

level

An appropriate isolation level for a given transation.

Return Value

Choosing an appropriate isolation level for a transaction depends on what happens within the transaction. However, not all transaction levels are supported by all databases (applicable). This usually depends on how isolation is implemented: whether through locking or versioning.

This method will return an isolation level, supported by the given database, that has at least the degree of isolation as requested.

For example: For a given transaction it is determined that isolation level "RepeatableRead" is required for correctness. While this will work for SQLServer, this isolation level is not supported by Oracle. For Oracle, you must use isolation level Serializable instead, for the same level of isolation.

Transactional COM+, by Tim Ewald, is an excellent reference on this topic. See chapter 7, Isolation (page 249).

Target Platforms: Windows XP SP3 (32-bit and 64-bit), Windows 7 (32-bit and 64-bit)

Not all Operating Systems are supported on all products. Visit the ArcFM Solution Supported Versions page for full details.

Reference

DataSyntax Class
DataSyntax Members