dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteTransactionMode Enumeration

In This Topic
    SQLiteTransactionMode Enumeration
    In This Topic
    Determines how the database is locked during transactions.
    Syntax
    'Declaration
     
    Public Enum SQLiteTransactionMode 
       Inherits System.Enum
       Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
    public enum SQLiteTransactionMode : System.Enum, System.IComparableSystem.IConvertibleSystem.IFormattable  
    Members
    MemberDescription
    DeferredNo locks are acquired on the database until the database is first accessed. The first read operation against a database creates a shared lock and the first write operation creates a reserved lock. This is the default behavior.
    ExclusiveAn exclusive transaction causes exclusive locks to be acquired on all databases. No other thread or process will be able to read or write the database until the transaction is complete.
    ImmediateReserved locks are acquired on all databases without waiting for the database to be used. No other thread or process will be able to write to the database or initiate immediate or exclusive transactions. However, other processes can continue to read from the database.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             Devart.Data.SQLite.SQLiteTransactionMode

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also