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

On this page
    SQLiteTransactionMode Enumeration
    On this page
    Determines how the database is locked during transactions.
    Syntax
    'Declaration
 
Public Enum SQLiteTransactionMode 
   Inherits System.Enum
   Implements System.IComparable, System.IConvertible, System.IFormattable 
    public enum SQLiteTransactionMode : System.Enum, System.IComparable, System.IConvertible, System.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

    See Also

    Reference

    Devart.Data.SQLite Namespace

     

     

    © 2008 - 2026 Devart. All Rights Reserved.

    Send Feedback