Firebird ADO.NET Provider SDK Documentation - v1.7

FbTransactionOptions Enumeration

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.

[Visual Basic]
<Serializable, _  Flags>
Public Enum FbTransactionOptions
[C#]
[Serializable]
[Flags]
public enum FbTransactionOptions

Members

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

Requirements

Namespace: FirebirdSql.Data.Firebird

Assembly: FirebirdSql.Data.Firebird (in FirebirdSql.Data.Firebird.dll)

See Also

FirebirdSql.Data.Firebird Namespace