| DatabaseConnection Methods |
The DatabaseConnection type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | Backup |
Performs a full backup from This to destConn.
|
| Execute(IDatabaseConnection, String) |
Compiles and executes a SQL statement.
|
| Execute(IDatabaseConnection, String, Object) |
Compiles and executes a SQL statement with the provided bind parameter values.
|
| ExecuteAll |
Compiles and executes multiple SQL statements.
|
| GetFileName |
Returns the filename associated with the database.
|
| OpenBlob |
Opens the blob located by the ColumnInfo and rowid for incremental I/O as a Stream.
|
| PrepareAll |
Compiles one or more SQL statements.
|
| PrepareStatement |
Compiles a SQL statement.
|
| Query(IDatabaseConnection, String) |
Compiles a SQL statement, returning the an IEnumerableT of rows in the result set.
|
| Query(IDatabaseConnection, String, Object) |
Compiles a SQL statement with provided bind parameter values,
returning the an IEnumerableT of rows in the result set.
|
| RunInTransaction(IDatabaseConnection, ActionIDatabaseConnection) |
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.
|
| RunInTransaction(IDatabaseConnection, ActionIDatabaseConnection, TransactionMode) |
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.
|
| RunInTransactionT(IDatabaseConnection, FuncIDatabaseConnection, T) |
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.
|
| RunInTransactionT(IDatabaseConnection, FuncIDatabaseConnection, T, TransactionMode) |
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.
|
| TryRunInTransaction(IDatabaseConnection, ActionIDatabaseConnection) |
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.
|
| TryRunInTransaction(IDatabaseConnection, ActionIDatabaseConnection, TransactionMode) |
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.
|
| TryRunInTransactionT(IDatabaseConnection, FuncIDatabaseConnection, T, T) |
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.
|
| TryRunInTransactionT(IDatabaseConnection, FuncIDatabaseConnection, T, TransactionMode, T) |
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.
|
| Vacuum |
Executes the SQLite VACUUM command
|
| WalCheckPoint |
Checkpoint the database name dbName.
|
See Also