| IDatabaseConnection Interface |
A connection to a SQLite database.
Namespace: SQLitePCL.pretty
Assembly: SQLitePCL.pretty (in SQLitePCL.pretty.dll) Version: 1.0.0.0 (1.0.0)
SyntaxThe 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.) |
Properties| Name | Description | |
|---|---|---|
 | Changes |
Returns the number of database rows that were changed, inserted
or deleted by the most recently completed IStatement.
|
| IsAutoCommit |
Returns true if the given database connection is in autocommit mode,
|
| IsReadOnly |
Returns true if the database connection is readonly.
|
| LastInsertedRowId |
Returns the rowid of the most recent successful INSERT into a rowid or virtual table.
|
| TotalChanges |
Returns the number of row changes caused by INSERT,
UPDATE or DELETE statements since the database connection was opened.
|
See Also