Name | Description | |
---|---|---|
SQLiteConnection Constructor | Overloaded. Initializes a new instance of the SQLiteConnection class. |
The following tables list the members exposed by SQLiteConnection.
Name | Description | |
---|---|---|
SQLiteConnection Constructor | Overloaded. Initializes a new instance of the SQLiteConnection class. |
Name | Description | |
---|---|---|
ConnectionString | Overridden. Gets or sets the string used to open a SQLite connection. | |
ConnectionTimeout | Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error. | |
Container | Gets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
Database | Overridden. Returns constant "Main". | |
DataSource | Gets or sets the location of the database. | |
InDistributedTransaction | Indicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase) | |
Name | Gets or sets the name of the component. | |
Owner | Gets or sets a form or other container that the SQLiteConnection instance belongs to. | |
ServerVersion | Gets a string containing the version of the instance of SQLite to which the client is connected. | |
Site | Gets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
State | Gets the current state of the connection. | |
UTF16 | Gets or sets a value indicating whether the connection uses UTF16 encoding. |
Name | Description | |
---|---|---|
BackupDatabase | Overloaded. Backups (copies) the database using the SQLite Online Backup API. | |
BeginOpen | Starts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase) | |
BeginTransaction | Overloaded. Begins a transaction at the database. | |
ChangeDatabase | Overridden. This method is not supported. | |
ChangePassword | Changes password for opened SEE or SQLiteCrypt encrypted SQLite databases. Accepts new password only in UTF-8 encoding. | |
ClearAllPools | Overloaded. Clears all pools associated with the connection. | |
ClearPool | Clears the pool matching ConnectionString of provided SQLiteConnection object. | |
Clone | Creates a new object that is a copy of the current instance. | |
Close | Closes the connection to the database. This is the preferred method of closing any open connection. (Inherited from Devart.Common.DbConnectionBase) | |
Commit | Commits the database transaction. | |
CreateCommand | Creates and returns a SQLiteCommand object associated with the SQLiteConnection. | |
CreateFile | Creates an empty database. | |
CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject) | |
DisableSharedCache | Disables the sharing of the database cache and schema data structures between connections to the same database. | |
Dispose | Releases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
EnableExtensions | ||
EnableSharedCache | Enables the sharing of the database cache and schema data structures between connections to the same database. | |
EndOpen | Ends an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase) | |
EnlistTransaction | Enlists in the specified transaction. (Inherited from Devart.Common.DbConnectionBase) | |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
GetSchema | Overloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase) | |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
IsFunctionRegistered | Overloaded. Checks whether the specified function is registered in the connection as SQLite user-defined function. | |
LoadExtension | Overloaded. Loads an SQLite extension library, specified by its file name. | |
Open | Overridden. Opens a SQLite connection with the property settings specified by the ConnectionString. | |
RegisterFunction | Registers user-defined function in the connection. | |
RegisterProgressHandler | Overloaded. Registers a handler to be invoked periodically during long running calls to a database. | |
Rollback | Rolls back a transaction from a pending state. | |
SQLCipherExport | Creates 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. | |
ToString | Returns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component) | |
UnRegisterCollation | Unregisters existing SQLite collation function. | |
UnRegisterFunction | Overloaded. Unregisters existing SQL scalar or aggregate function. | |
UnRegisterProgressHandler | Unregisters any registered SQLiteProgressCallback progress handler. |
Name | Description | |
---|---|---|
Disposed | Occurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component) | |
Error | Occurs when SQLite returns an error. | |
StateChange | Occurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase) | |
TransactionStateChanged | Occurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase) | |
TransactionStateChanging | Occurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase) |