DatabaseConnection Class

Extensions methods for IDatabaseConnection

Inheritance Hierarchy

SystemObject
SQLitePCL.prettyDatabaseConnection

Namespace: SQLitePCL.pretty
Assembly: SQLitePCL.pretty (in SQLitePCL.pretty.dll) Version: 1.0.0.0 (1.0.0)

Syntax

Copy

public static class DatabaseConnection

[<AbstractClassAttribute>]
[<SealedAttribute>]
[<ExtensionAttribute>]
type DatabaseConnection =  class end

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.

Top

Reference

SQLitePCL.pretty Namespace