| IDatabaseConnection Methods |
The IDatabaseConnection type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | GetTableColumnMetadata |
Returns metadata about a specific column of a specific database table,
|
| 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.
|
| 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 | |
|---|---|---|
 | 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.) |
| 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