IDatabaseConnection Methods |
The IDatabaseConnection type exposes the following members.
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.
|
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.) |