dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnection Class
Properties Methods Events

In This Topic
    SQLiteConnection Class Members
    In This Topic

    The following tables list the members exposed by SQLiteConnection.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the SQLiteConnection class.  
    Top
    Public Properties
     NameDescription
    Public PropertyOverridden. Gets or sets the string used to open a SQLite connection.  
    Public PropertyGets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
    Public PropertyGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyOverridden. Returns constant "Main".  
    Public PropertyGets or sets the location of the database.  
    Public PropertyIndicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase)
    Public PropertyGets or sets the name of the component.  
    Public PropertyGets or sets a form or other container that the SQLiteConnection instance belongs to.  
    Public PropertyGets a string containing the version of the instance of SQLite to which the client is connected.  
    Public PropertyGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyGets the current state of the connection.  
    Public PropertyGets or sets a value indicating whether the connection uses UTF16 encoding.  
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded. Backups (copies) the database using the SQLite Online Backup API.  
    Public MethodStarts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase)
    Public MethodOverloaded. Begins a transaction at the database.  
    Public MethodOverridden. This method is not supported.  
    Public MethodChanges password for opened SEE or SQLiteCrypt encrypted SQLite databases. Accepts new password only in UTF-8 encoding.  
    Public Methodstatic (Shared in Visual Basic)Overloaded. Clears all pools associated with the connection.  
    Public Methodstatic (Shared in Visual Basic)Clears the pool matching ConnectionString of provided SQLiteConnection object.  
    Public MethodCreates a new object that is a copy of the current instance.  
    Public MethodCloses the connection to the database. This is the preferred method of closing any open connection. (Inherited from Devart.Common.DbConnectionBase)
    Public MethodCommits the database transaction.  
    Public MethodCreates and returns a SQLiteCommand object associated with the SQLiteConnection.  
    Public Methodstatic (Shared in Visual Basic)Creates an empty database.  
    Public MethodCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
    Public Methodstatic (Shared in Visual Basic)Disables the sharing of the database cache and schema data structures between connections to the same database.  
    Public MethodReleases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public Method  
    Public Methodstatic (Shared in Visual Basic)Enables the sharing of the database cache and schema data structures between connections to the same database.  
    Public MethodEnds an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase)
    Public MethodEnlists in the specified transaction. (Inherited from Devart.Common.DbConnectionBase)
    Public MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase)
    Public MethodObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Checks whether the specified function is registered in the connection as SQLite user-defined function.  
    Public MethodOverloaded. Loads an SQLite extension library, specified by its file name.  
    Public MethodOverridden. Opens a SQLite connection with the property settings specified by the ConnectionString.  
    Public MethodRegisters user-defined function in the connection.  
    Public MethodOverloaded. Registers a handler to be invoked periodically during long running calls to a database.  
    Public MethodRolls back a transaction from a pending state.  
    Public MethodCreates an SQLCipher-encrypted copy of the current unencrypted database. You must have the SQLite3.dll library with SQLCipher extension in order to use this method.  
    Public MethodReturns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component)
    Public MethodUnregisters existing SQLite collation function.  
    Public MethodOverloaded. Unregisters existing SQL scalar or aggregate function.  
    Public MethodUnregisters any registered SQLiteProgressCallback progress handler.  
    Top
    Public Events
     NameDescription
    Public EventOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
    Public EventOccurs when SQLite returns an error.  
    Public EventOccurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase)
    Public EventOccurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase)
    Public EventOccurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase)
    Top
    See Also