SQLiteDatabaseConnection Class

An implementation of IDatabaseConnection that wraps a raw SQLite database connection.

Inheritance Hierarchy

SystemObject
SQLitePCL.prettySQLiteDatabaseConnection

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

Syntax

Copy

public sealed class SQLiteDatabaseConnection : IDatabaseConnection, 
	IDisposable

[<SealedAttribute>]
type SQLiteDatabaseConnection =  
    class
        interface IDatabaseConnection
        interface IDisposable
    end

The SQLiteDatabaseConnection type exposes the following members.

Methods

	Name	Description
	BackupInit	Initializes a backup of database to a destination database.
	Dispose	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Overrides ObjectFinalize.)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetTableColumnMetadata	Returns metadata about a specific column of a specific database table,
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	Interrupt	Causes any pending database operation to abort and return at its earliest opportunity.
	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.
	ToString	Returns a string that represents the current object. (Inherited from Object.)
	TryGetFileName	Returns the filename associated with the database if available.
	WalCheckPoint	Run a checkpoint operation on a WAL database on the connection. The specific operation is determined by the value of the mode parameter.

Top

Extension Methods

	Name	Description
	Backup	Performs a full backup from This to destConn. (Defined by DatabaseConnection.)
	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.)
	GetFileName	Returns the filename associated with the database. (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.)

Top

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.
	Statements	An enumeration of the connection's currently opened statements in the order they were prepared.
	TotalChanges	Returns the number of row changes caused by INSERT, UPDATE or DELETE statements since the database connection was opened.

Top

Events

	Name	Description
	Profile	Profiling event that occurs when a IStatement finishes.
	Rollback	Occurs whenever a transaction is rolled back on the database connection.
	Trace	Tracing event that occurs at various times when IStatementis running.
	Update	Occurs whenever a row is updated, inserted or deleted in a rowid table.

Top

Reference

SQLitePCL.pretty Namespace