Specifies Firebird transactions specific options that can be used with BeginTransaction.
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Member Name | Description | Value |
---|---|---|
Consistency | Table locking transaction model. | 1 |
Concurrency | High concurrency transaction with acceptable consistency. The use of this parameter takes full advantage multi-generational transaction model. | 2 |
Shared | Concurrent, shared access of a specified table among all transactions. Used with LockRead and Lock Write options to establish the lock option. | 4 |
Protected | Concurrent, restricted access of a specified table. Used with LockRead and Lock Write options to establish the lock option. | 8 |
Exclusive | Exclusive access of a specified table. | 16 |
Wait | Lock resolution specifies that the transaction is to wait until locked resources are released before retrying an operation. | 32 |
NoWait | Lock resolution specifies that the transaction is not to wait for locks to be released, but instead, a lock conflict error should be returned immediately. | 64 |
Read | Read-only access mode that allows a transaction only to select data. | 128 |
Write | Read-write access mode of that allows a transaction to select, insert, update, and delete table data. | 256 |
LockRead | Read only access of a specified table. Used with Shared, Protected and Exclusive options to establish the lock option. | 512 |
LockWrite | Read/write access of a specified table. Used with Shared, Protected and Exclusive options to establish the lock option. | 1024 |
ReadCommitted | High throughput, high concurrency transaction that can read changes committed by other concurrent transactions. The use of this parameter takes full advantage multi-generational transaction model. | 2048 |
Autocommit | 4096 | |
RecVersion | Enables an ReadCommitted transaction to read the most recently committed version of a record even if other, uncommitted versions are pending. | 8192 |
NoRecVersion | Enables an ReadCommitted transaction to read only the latest committed version of a record. If an uncommitted version of a record is pending and Wait is also specified, then the transaction waits for the pending record to be committed or rolled back before proceeding. Otherwise, a lock conflict error is reported at once. | 16384 |
RestartRequests | 32768 | |
NoAutoUndo | 65536 |
Namespace: FirebirdSql.Data.Firebird
Assembly: FirebirdSql.Data.Firebird (in FirebirdSql.Data.Firebird.dll)
FirebirdSql.Data.Firebird Namespace