Skip to end of metadata
Go to start of metadata

Represents SQLite3 commands execution.

Definition

public static class SQLite3

Summary

The following table summarizes the members exposed in this class.

Static Methods

BindBlob(Statement, int, Byte[], int, IntPtr) Executes sqlite3_bind_blob command.
BindDouble(Statement, int, double) Executes sqlite3_bind_double command.
BindInt(Statement, int, int) Executes sqlite3_bind_int command.
BindInt64(Statement, int, long) Executes sqlite3_bind_int64 command.
BindNull(Statement, int) Executes sqlite3_bind_null command.
BindParameterIndex(Statement, string) Executes sqlite3_bind_parameter_index command.
BindText(Statement, int, string, int, IntPtr) Executes sqlite3_bind_text command.
BusyTimeout(Database, int) Executes sqlite3_busy_timeout command.
Changes(Database) Executes sqlite3_changes command.
Close(Database) Executes sqlite3_close command.
ColumnBlob(Statement, int) Executes sqlite3_column_blob command.
ColumnByteArray(Statement, int) Gets column byte array.
ColumnBytes(Statement, int) Executes sqlite3_column_bytes command.
ColumnCount(Statement) Executes sqlite3_column_count command.
ColumnDouble(Statement, int) Executes sqlite3_column_double command.
ColumnInt(Statement, int) Executes sqlite3_column_int command.
ColumnInt64(Statement, int) Executes sqlite3_column_int64 command.
ColumnName(Statement, int) Executes sqlite3_column_name command.
ColumnName16(Statement, int) Executes sqlite3_column_name16 command
ColumnString(Statement, int) Executes sqlite3_column_text command.
ColumnText(Statement, int) Executes sqlite3_column_text command.
ColumnText16(Statement, int) Executes sqlite3_column_text command.
ColumnType(Statement, int) Executes sqlite3_column_type command.
Finalize(Statement) Executes sqlite3_finalize command.
GetErrMsg(Database) Executes sqlite3_errormsg command.
LastInsertRowid(Database) Executes sqlite3_last_insert_rowid command.
Open(string, out Database) Execute sqlite3_open command.
Open(string, out Database, int, IntPtr) Executes sqlite3_open_v2 command.
Prepare2(Database, string) Executes sqlite3_prepare_v2 command.
Reset(Statement) Executes sqlite3_reset command.
Step(Statement) Executes sqlite3_step command.

Static Methods

public static int BindBlob(Statement stmt, int index, Byte[] val, int n, IntPtr free)

Executes sqlite3_bind_blob command.

Parameters

stmt
index
val
n
free

public static int BindDouble(Statement stmt, int index, double val)

Executes sqlite3_bind_double command.

Parameters

stmt
index
val

public static int BindInt(Statement stmt, int index, int val)

Executes sqlite3_bind_int command.

Parameters

stmt
index
val

public static int BindInt64(Statement stmt, int index, long val)

Executes sqlite3_bind_int64 command.

Parameters

stmt
index
val

public static int BindNull(Statement stmt, int index)

Executes sqlite3_bind_null command.

Parameters

stmt
index

public static int BindParameterIndex(Statement stmt, string name)

Executes sqlite3_bind_parameter_index command.

Parameters

stmt
name

public static int BindText(Statement stmt, int index, string val, int n, IntPtr free)

Executes sqlite3_bind_text command.

Parameters

stmt
index
val
n
free

public static Result BusyTimeout(Database db, int milliseconds)

Executes sqlite3_busy_timeout command.

Parameters

db
milliseconds

public static int Changes(Database db)

Executes sqlite3_changes command.

Parameters

db

public static Result Close(Database db)

Executes sqlite3_close command.

Parameters

db

public static Byte[] ColumnBlob(Statement stmt, int index)

Executes sqlite3_column_blob command.

Parameters

stmt
index

public static Byte[] ColumnByteArray(Statement stmt, int index)

Gets column byte array.

Parameters

stmt
index

public static int ColumnBytes(Statement stmt, int index)

Executes sqlite3_column_bytes command.

Parameters

stmt
index

public static int ColumnCount(Statement stmt)

Executes sqlite3_column_count command.

Parameters

stmt

public static double ColumnDouble(Statement stmt, int index)

Executes sqlite3_column_double command.

Parameters

stmt
index

public static int ColumnInt(Statement stmt, int index)

Executes sqlite3_column_int command.

Parameters

stmt
index

public static long ColumnInt64(Statement stmt, int index)

Executes sqlite3_column_int64 command.

Parameters

stmt
index

public static string ColumnName(Statement stmt, int index)

Executes sqlite3_column_name command.

Parameters

stmt
index

public static string ColumnName16(Statement stmt, int index)

Executes sqlite3_column_name16 command

Parameters

stmt
index

public static string ColumnString(Statement stmt, int index)

Executes sqlite3_column_text command.

Parameters

stmt
index

public static string ColumnText(Statement stmt, int index)

Executes sqlite3_column_text command.

Parameters

stmt
index

public static string ColumnText16(Statement stmt, int index)

Executes sqlite3_column_text command.

Parameters

stmt
index

public static ColumnType ColumnType(Statement stmt, int index)

Executes sqlite3_column_type command.

Parameters

stmt
index

public static Result Finalize(Statement stmt)

Executes sqlite3_finalize command.

Parameters

stmt

public static string GetErrMsg(Database db)

Executes sqlite3_errormsg command.

Parameters

db

public static long LastInsertRowid(Database db)

Executes sqlite3_last_insert_rowid command.

Parameters

db

public static Result Open(string filename, out Database db)

Execute sqlite3_open command.

Parameters

filename
db

public static Result Open(string filename, out Database db, int flags, IntPtr zVfs)

Executes sqlite3_open_v2 command.

Parameters

filename
db
flags
zVfs

public static Statement Prepare2(Database db, string query)

Executes sqlite3_prepare_v2 command.

Parameters

db
query

public static Result Reset(Statement stmt)

Executes sqlite3_reset command.

Parameters

stmt

public static Result Step(Statement stmt)

Executes sqlite3_step command.

Parameters

stmt
  • No labels