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(IntPtr, int, Byte[], int, IntPtr) Executes sqlite3_bind_blob command.
BindDouble(IntPtr, int, double) Executes sqlite3_bind_double command.
BindInt(IntPtr, int, int) Executes sqlite3_bind_int command.
BindInt64(IntPtr, int, long) Executes sqlite3_bind_int64 command.
BindNull(IntPtr, int) Executes sqlite3_bind_null command.
BindParameterIndex(IntPtr, string) Executes sqlite3_bind_parameter_index command.
BindText(IntPtr, int, string, int, IntPtr) Executes sqlite3_bind_text16 command.
BusyTimeout(IntPtr, int) Executes sqlite3_busy_timeout command.
Changes(IntPtr) Executes sqlite3_changes command.
Close(IntPtr) Executes sqlite3_close command.
ColumnBlob(IntPtr, int) Executes sqlite3_column_blob.
ColumnByteArray(IntPtr, int) Gets column byte array.
ColumnBytes(IntPtr, int) Executes sqlite3_column_bytes.
ColumnCount(IntPtr) Executes sqlite3_column_count command.
ColumnDouble(IntPtr, int) Executes sqlite3_column_double.
ColumnInt(IntPtr, int) Executes sqlite3_column_int.
ColumnInt64(IntPtr, int) Executes sqlite3_column_int64.
ColumnName(IntPtr, int) Executes sqlite3_column_name command.
ColumnName16(IntPtr, int) Executes sqlite3_column_name16.
ColumnString(IntPtr, int) Executes sqlite3_column_string.
ColumnText(IntPtr, int) Executes sqlite3_column_text.
ColumnText16(IntPtr, int) Executes sqlite3_column_text16.
ColumnType(IntPtr, int) Executes sqlite3_column_type.
Config(ConfigOption) Executes sqlite3_config command.
Errmsg(IntPtr) Executes sqlite3_errmsg16 command.
Finalize(IntPtr) Executes sqlite3_finalize command.
GetErrMsg(IntPtr) Gets error message from sqlite3_errmsg16 command.
LastInsertRowid(IntPtr) Executes sqlite3_last_insert_rowid command.
Open(string, out IntPtr) Executes sqlite3_open command.
Open(string, out IntPtr, int, IntPtr) Executes sqlite3_open_v2 command.
Open(Byte[], out IntPtr, int, IntPtr) Executes sqlite3_open_v2 command.
Open16(string, out IntPtr) Executes sqlite3 open16 command.
Prepare2(IntPtr, string, int, out IntPtr, IntPtr) Executes sqlite3_prepare_v2 command.
Prepare2(IntPtr, string) Executes sqlite3_prepare_v2 command.
Reset(IntPtr) Executes sqlite3_reset command.
SetDirectory(uint, string) Executes sqlite3_win32_set_directory command.
Step(IntPtr) Executes sqlite3_step command.

Static Methods

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

Executes sqlite3_bind_blob command.

Parameters

stmt
index
val
n
free

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

Executes sqlite3_bind_double command.

Parameters

stmt
index
val

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

Executes sqlite3_bind_int command.

Parameters

stmt
index
val

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

Executes sqlite3_bind_int64 command.

Parameters

stmt
index
val

public static int BindNull(IntPtr stmt, int index)

Executes sqlite3_bind_null command.

Parameters

stmt
index

public static int BindParameterIndex(IntPtr stmt, string name)

Executes sqlite3_bind_parameter_index command.

Parameters

stmt
name

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

Executes sqlite3_bind_text16 command.

Parameters

stmt
index
val
n
free

public static Result BusyTimeout(IntPtr db, int milliseconds)

Executes sqlite3_busy_timeout command.

Parameters

db
milliseconds

public static int Changes(IntPtr db)

Executes sqlite3_changes command.

Parameters

db

public static Result Close(IntPtr db)

Executes sqlite3_close command.

Parameters

db

public static IntPtr ColumnBlob(IntPtr stmt, int index)

Executes sqlite3_column_blob.

Parameters

stmt
index

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

Gets column byte array.

Parameters

stmt
index

public static int ColumnBytes(IntPtr stmt, int index)

Executes sqlite3_column_bytes.

Parameters

stmt
index

public static int ColumnCount(IntPtr stmt)

Executes sqlite3_column_count command.

Parameters

stmt

public static double ColumnDouble(IntPtr stmt, int index)

Executes sqlite3_column_double.

Parameters

stmt
index

public static int ColumnInt(IntPtr stmt, int index)

Executes sqlite3_column_int.

Parameters

stmt
index

public static long ColumnInt64(IntPtr stmt, int index)

Executes sqlite3_column_int64.

Parameters

stmt
index

public static IntPtr ColumnName(IntPtr stmt, int index)

Executes sqlite3_column_name command.

Parameters

stmt
index

public static string ColumnName16(IntPtr stmt, int index)

Executes sqlite3_column_name16.

Parameters

stmt
index

public static string ColumnString(IntPtr stmt, int index)

Executes sqlite3_column_string.

Parameters

stmt
index

public static IntPtr ColumnText(IntPtr stmt, int index)

Executes sqlite3_column_text.

Parameters

stmt
index

public static IntPtr ColumnText16(IntPtr stmt, int index)

Executes sqlite3_column_text16.

Parameters

stmt
index

public static ColumnType ColumnType(IntPtr stmt, int index)

Executes sqlite3_column_type.

Parameters

stmt
index

public static Result Config(ConfigOption option)

Executes sqlite3_config command.

Parameters

option

public static IntPtr Errmsg(IntPtr db)

Executes sqlite3_errmsg16 command.

Parameters

db

public static Result Finalize(IntPtr stmt)

Executes sqlite3_finalize command.

Parameters

stmt

public static string GetErrMsg(IntPtr db)

Gets error message from sqlite3_errmsg16 command.

Parameters

db

public static long LastInsertRowid(IntPtr db)

Executes sqlite3_last_insert_rowid command.

Parameters

db

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

Executes sqlite3_open command.

Parameters

filename
db

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

Executes sqlite3_open_v2 command.

Parameters

filename
db
flags
zvfs

public static Result Open(Byte[] filename, out IntPtr db, int flags, IntPtr zvfs)

Executes sqlite3_open_v2 command.

Parameters

filename
db
flags
zvfs

public static Result Open16(string filename, out IntPtr db)

Executes sqlite3 open16 command.

Parameters

filename
db

public static Result Prepare2(IntPtr db, string sql, int numBytes, out IntPtr stmt, IntPtr pzTail)

Executes sqlite3_prepare_v2 command.

Parameters

db
sql
numBytes
stmt
pzTail

public static IntPtr Prepare2(IntPtr db, string query)

Executes sqlite3_prepare_v2 command.

Parameters

db
query

public static Result Reset(IntPtr stmt)

Executes sqlite3_reset command.

Parameters

stmt

public static int SetDirectory(uint directoryType, string directoryPath)

Executes sqlite3_win32_set_directory command.

Parameters

directoryType
directoryPath

public static Result Step(IntPtr stmt)

Executes sqlite3_step command.

Parameters

stmt
  • No labels