SqliteConnection Class

Definition

Represents a connection to a SQLite database.

public class SqliteConnection : System.Data.Common.DbConnection
type SqliteConnection = class
    inherit DbConnection
Public Class SqliteConnection
Inherits DbConnection
Inheritance
SqliteConnection

Constructors

SqliteConnection()

Initializes a new instance of the SqliteConnection class.

SqliteConnection(String)

Initializes a new instance of the SqliteConnection class.

Properties

ConnectionString

Gets or sets a string used to open the connection.

Database

Gets the name of the current database. Always 'main'.

DataSource

Gets the path to the database file. Will be absolute for open connections.

DbProviderFactory

Gets the DbProviderFactory for this connection.

DefaultTimeout

Gets or sets the default CommandTimeout value for commands created using this connection. This is also used for internal commands in methods like BeginTransaction().

Handle

Gets a handle to underlying database connection.

ServerVersion

Gets the version of SQLite used by the connection.

State

Gets the current state of the connection.

Transaction

Gets or sets the transaction currently being used by the connection, or null if none.

Methods

BackupDatabase(SqliteConnection)

Backup of the connected database.

BackupDatabase(SqliteConnection, String, String)

Backup of the connected database.

BeginDbTransaction(IsolationLevel)

Begins a transaction on the connection.

BeginTransaction()

Begins a transaction on the connection.

BeginTransaction(Boolean)

Begins a transaction on the connection.

BeginTransaction(IsolationLevel)

Begins a transaction on the connection.

BeginTransaction(IsolationLevel, Boolean)

Begins a transaction on the connection.

ChangeDatabase(String)

Changes the current database. Not supported.

ClearAllPools()

Empties the connection pool.

ClearPool(SqliteConnection)

Empties the connection pool associated with the connection.

Close()

Closes the connection to the database. Open transactions are rolled back.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, T15,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate, T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, T15,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7, T8,T9,T10,T11,T12,T13,T14,T15,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, T15,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2, T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1, T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,TAccumulate>, Func<TAccumulate, TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8, T9,T10,T11,T12,T13,T14,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4, T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,TAccumulate, TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5, T6,T7,T8,T9,T10,T11,T12,T13,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13, TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10, T11,T12,T13,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,TAccumulate, TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5, T6,T7,T8,T9,T10,T11,T12,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10, T11,T12,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TAccumulate, TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5, T6,T7,T8,T9,T10,T11,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10, T11,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10, TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10, TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,T9,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,T9,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,T8,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,T8,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,T7,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,T7,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,T6,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,T6,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,T6,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,TAccumulate>, Func<TAccumulate, TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,T5,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,T5,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,T5,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,T4,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,T4,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,T4,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,TAccumulate>(String, Func<TAccumulate,T1,T2,T3,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,T3,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,T3,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,T2,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,TAccumulate>(String, Func<TAccumulate,T1,T2,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,T2,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,T2,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,T1,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,TAccumulate>(String, Func<TAccumulate,T1,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<T1,TAccumulate>(String, TAccumulate, Func<TAccumulate,T1,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,Object[],TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<TAccumulate,TResult>(String, TAccumulate, Func<TAccumulate,TAccumulate>, Func<TAccumulate,TResult>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<TAccumulate>(String, Func<TAccumulate,Object[],TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<TAccumulate>(String, Func<TAccumulate,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<TAccumulate>(String, TAccumulate, Func<TAccumulate,Object[],TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateAggregate<TAccumulate>(String, TAccumulate, Func<TAccumulate,TAccumulate>, Boolean)

Creates or redefines an aggregate SQL function.

CreateCollation(String, Comparison<String>)

Create custom collation.

CreateCollation<T>(String, T, Func<T,String,String,Int32>)

Create custom collation.

CreateCommand()

Creates a new command associated with the connection.

CreateDbCommand()

Creates a new command associated with the connection.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, T15,T16,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10, T11,T12,T13,T14,T15,T16,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14, T15,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11, T12,T13,T14,T15,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,T9,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,T9,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,T8,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,T8,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,T7,TResult>(String, Func<T1,T2,T3,T4,T5,T6,T7,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,T6,TResult>(String, Func<T1,T2,T3,T4,T5,T6,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,T5,TResult>(String, Func<T1,T2,T3,T4,T5,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,T4,TResult>(String, Func<T1,T2,T3,T4,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,T3,TResult>(String, Func<T1,T2,T3,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,T2,TResult>(String, Func<T1,T2,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<T1,TResult>(String, Func<T1,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TResult>(String, Func<Object[],TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TResult>(String, Func<TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12, T13,T14,T15,TResult>(String, TState, Func<TState,T1,T2,T3,T4, T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12, T13,T14,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6, T7,T8,T9,T10,T11,T12,T13,T14,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12, T13,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,T7, T8,T9,T10,T11,T12,T13,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12, TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,T7,T8, T9,T10,T11,T12,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,T7,T8,T9,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,T8,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,T7,T8,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,T7,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,T7,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,T6,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,T6,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,T5,TResult>(String, TState, Func<TState,T1,T2,T3,T4,T5,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,T4,TResult>(String, TState, Func<TState,T1,T2,T3,T4,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,T3,TResult>(String, TState, Func<TState,T1,T2,T3,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,T2,TResult>(String, TState, Func<TState,T1,T2,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,T1,TResult>(String, TState, Func<TState,T1,TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,TResult>(String, TState, Func<TState,Object[],TResult>, Boolean)

Creates or redefines a SQL function.

CreateFunction<TState,TResult>(String, TState, Func<TState,TResult>, Boolean)

Creates or redefines a SQL function.

Dispose(Boolean)

Releases any resources used by the connection and closes it.

EnableExtensions(Boolean)

Enables extension loading on the connection.

GetSchema()

Returns schema information for the data source of this conneciton.

GetSchema(String)

Returns schema information for the data source of this conneciton.

GetSchema(String, String[])

Returns schema information for the data source of this conneciton.

LoadExtension(String, String)

Loads a SQLite extension library.

Open()

Opens a connection to the database using the value of ConnectionString. If Mode=ReadWriteCreate is used (the default) the file is created, if it doesn't already exist.

Applies to