 |
|
You can use the IsolationLevel attribute to set the separation between multiple transactions. Resetting the IsolationLevel does not have an effect until BeginTransaction is called again.
|
Syntax | |
|
IsolationLevel | |
|
Return value | |
|
Type |
Description |
|
ConnIsolationLevel |
Process separation |
|
ConnIsolationLevel |
Description |
|
256 – CILBrowse |
Determines that uncommitted changes to other transactions are also visible |
|
16 – CILChaos |
Determines that pending changes to a transaction with Heightrem isolation value must not be overwritten |
|
4096 - CILCursorStability |
Default: Changes in other transactions are not visible until after commit |
|
1048576 - CILIsolated |
Specifies that transaction is performed completely in isolation from other transactions |
|
4096 - CILReadCommitted |
Like CILCursorStability |
|
256 - CILReadUnCommitted |
Like CILBrowse |
|
65536 - CILRepeatableRead |
Specifies that changes to other pending transactions are not visible, but re-access makes data changes visible |
|
1048576 - CILSerializable |
Like CILIsolated |
|
-1 - CILUnspecified |
IsolationLevel is not specified |
Contents
Index
Previous
Next