SqliteConnection Class

Definition

Namespace:

Microsoft.Data.Sqlite

Assembly:

Microsoft.Data.Sqlite.dll

Package:

Microsoft.Data.Sqlite.Core v8.0.0

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

DbConnection

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, String, String)	Backup of the connected database.
BackupDatabase(SqliteConnection)	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, Boolean)	Begins a transaction on the connection.
BeginTransaction(IsolationLevel)	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, String[])	Returns schema information for the data source of this conneciton.
GetSchema(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.