Skip to end of metadata
Go to start of metadata

Represents an open connection to a SQLite database.

Definition

public class SQLiteConnection : SQLiteConnectionBase

Summary

The following table summarizes the members exposed in this class.

Public Constructors

SQLiteConnection Constructor(string) Initializes a new instance of the SQLiteConnectionBase class and opens a SQLite database specified by databasePath.
SQLiteConnection Constructor(string, SQLiteOpenFlags) Initializes a new instance of the SQLiteConnectionBase class and opens a SQLite database specified by databasePath.

Public Properties

BusyTimeout Gets or sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sleep multiple times until a total time of SQLiteConnection has accumulated.
Handle Gets the SQLite database handle.

Protected Methods

CloseImplementation() Handles close connection.
DoSavePointExecute(string, string) Handles execute save point.
ExecuteImplementation(string, Object[]) Handles execute query.
ExecuteScalarImplementation<T>(string, Object[]) Handles execute scalar query.
NewCommand() Creates a new SQLiteCommand.
OpenImplementation(string, SQLiteOpenFlags) Handles open connection.

Public Constructors

public SQLiteConnection(string databasePath)

Initializes a new instance of the SQLiteConnectionBase class and opens a SQLite database specified by databasePath.

Parameters

databasePath The database path.

public SQLiteConnection(string databasePath, SQLiteOpenFlags openFlags)

Initializes a new instance of the SQLiteConnectionBase class and opens a SQLite database specified by databasePath.

Parameters

databasePath The database path.
openFlags The open flags.

Public Properties

public TimeSpan BusyTimeout { get; set; }

Gets or sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sleep multiple times until a total time of SQLiteConnection has accumulated.

public IntPtr Handle { get; }

Gets the SQLite database handle.

Protected Methods

protected void CloseImplementation()

Handles close connection.

protected void DoSavePointExecute(string savePoint, string command)

Handles execute save point.

Parameters

savePoint The name of the save point.
command The name of the command.

protected int ExecuteImplementation(string query, Object[] args)

Handles execute query.

Parameters

query The query.
args Arguments.

protected T ExecuteScalarImplementation<T>(string query, Object[] arguments)

Handles execute scalar query.

Type Parameters

T The entity type.

Parameters

query The query.
arguments Arguments.

protected ISQLiteCommand NewCommand()

Creates a new SQLiteCommand.

protected void OpenImplementation(string databasePath, SQLiteOpenFlags openFlags)

Handles open connection.

Parameters

databasePath The database path.
openFlags The open flags.
  • No labels