| SQLiteDatabaseConnection Methods |
The SQLiteDatabaseConnection type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | BackupInit |
Initializes a backup of database to a destination database.
|
| Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Overrides ObjectFinalize.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetTableColumnMetadata |
Returns metadata about a specific column of a specific database table,
|
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| Interrupt |
Causes any pending database operation to abort and return at its earliest opportunity.
|
| IsDatabaseReadOnly |
Determine whether a database is readonly.
|
| OpenBlob |
Opens the blob located by the a database, table, column, and rowid for incremental I/O as a Stream.
|
| PrepareStatement |
Compiles a SQL statement into an IStatement.
|
| Status |
Retrieve runtime status information about a single database connection.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| TryGetFileName |
Returns the filename associated with the database if available.
|
| WalCheckPoint |
Run a checkpoint operation on a WAL database on the connection. The specific operation
is determined by the value of the mode parameter.
|
Extension Methods| Name | Description | |
|---|---|---|
 | Backup |
Performs a full backup from This to destConn.
(Defined by DatabaseConnection.) |
| DeleteAllT |
Deleted all object instances specified by their primary keys.
(Defined by DatabaseConnection.) |
| DeleteAllRowsT |
Deletes all rows in a given table.
(Defined by DatabaseConnection.) |
| DropTableIfExistsT |
Drops the table if it exists. Otherwise this is a no-op.
(Defined by DatabaseConnection.) |
| Execute(String) | Overloaded.
Compiles and executes a SQL statement.
(Defined by DatabaseConnection.) |
| Execute(String, Object) | Overloaded.
Compiles and executes a SQL statement with the provided bind parameter values.
(Defined by DatabaseConnection.) |
| ExecuteAll |
Compiles and executes multiple SQL statements.
(Defined by DatabaseConnection.) |
| FindAllT |
Finds all object instances specified by their primary keys.
(Defined by DatabaseConnection.) |
| GetFileName |
Returns the filename associated with the database.
(Defined by DatabaseConnection.) |
| InitTableT |
Creates or migrate a table in the database for the given table mapping, creating indexes if needed.
(Defined by DatabaseConnection.) |
| InsertOrReplaceT |
Inserts an object into the database, replacing the existing entry if the primary key already exists.
(Defined by DatabaseConnection.) |
| InsertOrReplaceAllT |
Inserts the objects into the database, replacing existing entries if the given primary keys already exist.
(Defined by DatabaseConnection.) |
| OpenBlob |
Opens the blob located by the ColumnInfo and rowid for incremental I/O as a Stream.
(Defined by DatabaseConnection.) |
| PrepareAll |
Compiles one or more SQL statements.
(Defined by DatabaseConnection.) |
| PrepareDeleteStatementT |
Prepares a SQLite statement that can be bound to an object primary key to delete row from the database.
(Defined by DatabaseConnection.) |
| PrepareFindStatementT |
Prepares a SQLite statement that can be bound to an object primary key to retrieve an instance from the database.
(Defined by DatabaseConnection.) |
| PrepareInsertOrReplaceStatementT |
Prepares a SQLite statement that can be bound to an object of type T to insert into the database.
(Defined by DatabaseConnection.) |
| PrepareStatement(String) | Overloaded.
Compiles a SQL statement.
(Defined by DatabaseConnection.) |
| PrepareStatement(ISqlQuery) | Overloaded.
Compiles a SQL query.
(Defined by DatabaseConnection.) |
| Query(String) | Overloaded.
Compiles a SQL statement, returning the an IEnumerableT of rows in the result set.
(Defined by DatabaseConnection.) |
| Query(ISqlQuery) | Overloaded.
Compiles a SQL query, returning the an IEnumerableT of rows in the result set.
(Defined by DatabaseConnection.) |
| Query(String, Object) | Overloaded.
Compiles a SQL statement with provided bind parameter values,
returning the an IEnumerableT of rows in the result set.
(Defined by DatabaseConnection.) |
| Query(ISqlQuery, Object) | Overloaded.
Compiles a SQL statement with provided bind parameter values,
returning the an IEnumerableT of rows in the result set.
(Defined by DatabaseConnection.) |
| RunInTransaction(ActionIDatabaseConnection) | Overloaded.
Runs the Action action in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
BeginTransaction with TransactionMode.Deferred and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| RunInTransaction(ActionIDatabaseConnection, TransactionMode) | Overloaded.
Runs the Action action in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
the provided TransactionMode and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| RunInTransactionT(FuncIDatabaseConnection, T) | Overloaded.
Runs the function f in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
BeginTransaction with TransactionMode.Deferred and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| RunInTransactionT(FuncIDatabaseConnection, T, TransactionMode) | Overloaded.
Runs the function f in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
the provided TransactionMode and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| TryDeleteT |
Tries to delete the object in the database with the provided primary key.
(Defined by DatabaseConnection.) |
| TryFindT |
Tries to find an object in the database with the provided primary key.
(Defined by DatabaseConnection.) |
| TryRunInTransaction(ActionIDatabaseConnection) | Overloaded.
Runs the Action action in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
BeginTransaction with TransactionMode.Deferred and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| TryRunInTransaction(ActionIDatabaseConnection, TransactionMode) | Overloaded.
Runs the Action action in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
the provided TransactionMode and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| TryRunInTransactionT(FuncIDatabaseConnection, T, T) | Overloaded.
Runs the function f in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
BeginTransaction with TransactionMode.Deferred and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| TryRunInTransactionT(FuncIDatabaseConnection, T, TransactionMode, T) | Overloaded.
Runs the function f in a transaction and returns the function result.
If the database is not currently in a transaction, a new transaction is created using
the provided TransactionMode and committed. Otherwise the transaction is created within
a savepoint block but not fully committed to the database until the enclosing transaction is committed.
(Defined by DatabaseConnection.) |
| Vacuum |
Executes the SQLite VACUUM command
(Defined by DatabaseConnection.) |
| WalCheckPoint |
Checkpoint the database name dbName.
(Defined by DatabaseConnection.) |
See Also