Class SQLite3
Syntax
public static class SQLite3
Methods
BindBlob(IntPtr, Int32, Byte[], Int32, IntPtr)
Declaration
public static extern int BindBlob(IntPtr stmt, int index, byte[] val, int n, IntPtr free)
Parameters
Returns
BindDouble(IntPtr, Int32, Double)
Declaration
public static extern int BindDouble(IntPtr stmt, int index, double val)
Parameters
Returns
BindInt(IntPtr, Int32, Int32)
Declaration
public static extern int BindInt(IntPtr stmt, int index, int val)
Parameters
Returns
BindInt64(IntPtr, Int32, Int64)
Declaration
public static extern int BindInt64(IntPtr stmt, int index, long val)
Parameters
Returns
BindNull(IntPtr, Int32)
Declaration
public static extern int BindNull(IntPtr stmt, int index)
Parameters
Returns
BindParameterIndex(IntPtr, String)
Declaration
public static extern int BindParameterIndex(IntPtr stmt, string name)
Parameters
Returns
BindText(IntPtr, Int32, String, Int32, IntPtr)
Declaration
public static extern int BindText(IntPtr stmt, int index, string val, int n, IntPtr free)
Parameters
Returns
BusyTimeout(IntPtr, Int32)
Declaration
public static extern SQLite3.Result BusyTimeout(IntPtr db, int milliseconds)
Parameters
Returns
Changes(IntPtr)
Declaration
public static extern int Changes(IntPtr db)
Parameters
| Type |
Name |
Description |
| IntPtr |
db |
|
Returns
Close(IntPtr)
Declaration
public static extern SQLite3.Result Close(IntPtr db)
Parameters
| Type |
Name |
Description |
| IntPtr |
db |
|
Returns
ColumnBlob(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnBlob(IntPtr stmt, int index)
Parameters
Returns
ColumnByteArray(IntPtr, Int32)
Declaration
public static byte[] ColumnByteArray(IntPtr stmt, int index)
Parameters
Returns
ColumnBytes(IntPtr, Int32)
Declaration
public static extern int ColumnBytes(IntPtr stmt, int index)
Parameters
Returns
ColumnCount(IntPtr)
Declaration
public static extern int ColumnCount(IntPtr stmt)
Parameters
| Type |
Name |
Description |
| IntPtr |
stmt |
|
Returns
ColumnDouble(IntPtr, Int32)
Declaration
public static extern double ColumnDouble(IntPtr stmt, int index)
Parameters
Returns
ColumnInt(IntPtr, Int32)
Declaration
public static extern int ColumnInt(IntPtr stmt, int index)
Parameters
Returns
ColumnInt64(IntPtr, Int32)
Declaration
public static extern long ColumnInt64(IntPtr stmt, int index)
Parameters
Returns
ColumnName(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnName(IntPtr stmt, int index)
Parameters
Returns
ColumnName16(IntPtr, Int32)
Declaration
public static string ColumnName16(IntPtr stmt, int index)
Parameters
Returns
ColumnString(IntPtr, Int32)
Declaration
public static string ColumnString(IntPtr stmt, int index)
Parameters
Returns
ColumnText(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnText(IntPtr stmt, int index)
Parameters
Returns
ColumnText16(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnText16(IntPtr stmt, int index)
Parameters
Returns
ColumnType(IntPtr, Int32)
Declaration
public static extern SQLite3.ColType ColumnType(IntPtr stmt, int index)
Parameters
Returns
Config(SQLite3.ConfigOption)
Declaration
public static extern SQLite3.Result Config(SQLite3.ConfigOption option)
Parameters
Returns
EnableLoadExtension(IntPtr, Int32)
Declaration
public static extern SQLite3.Result EnableLoadExtension(IntPtr db, int onoff)
Parameters
Returns
Errmsg(IntPtr)
Declaration
public static extern IntPtr Errmsg(IntPtr db)
Parameters
| Type |
Name |
Description |
| IntPtr |
db |
|
Returns
ExtendedErrCode(IntPtr)
Declaration
public static extern SQLite3.ExtendedResult ExtendedErrCode(IntPtr db)
Parameters
| Type |
Name |
Description |
| IntPtr |
db |
|
Returns
Finalize(IntPtr)
Declaration
public static extern SQLite3.Result Finalize(IntPtr stmt)
Parameters
| Type |
Name |
Description |
| IntPtr |
stmt |
|
Returns
GetErrmsg(IntPtr)
Declaration
public static string GetErrmsg(IntPtr db)
Parameters
| Type |
Name |
Description |
| IntPtr |
db |
|
Returns
Initialize()
Declaration
public static extern SQLite3.Result Initialize()
Returns
LastInsertRowid(IntPtr)
Declaration
public static extern long LastInsertRowid(IntPtr db)
Parameters
| Type |
Name |
Description |
| IntPtr |
db |
|
Returns
LibVersionNumber()
Declaration
public static extern int LibVersionNumber()
Returns
Open(Byte[], out IntPtr, Int32, IntPtr)
Declaration
public static extern SQLite3.Result Open(byte[] filename, out IntPtr db, int flags, IntPtr zvfs)
Parameters
Returns
Open(String, out IntPtr)
Declaration
public static extern SQLite3.Result Open(string filename, out IntPtr db)
Parameters
Returns
Open(String, out IntPtr, Int32, IntPtr)
Declaration
public static extern SQLite3.Result Open(string filename, out IntPtr db, int flags, IntPtr zvfs)
Parameters
Returns
Open16(String, out IntPtr)
Declaration
public static extern SQLite3.Result Open16(string filename, out IntPtr db)
Parameters
Returns
Prepare2(IntPtr, String)
Declaration
public static IntPtr Prepare2(IntPtr db, string query)
Parameters
Returns
Prepare2(IntPtr, String, Int32, out IntPtr, IntPtr)
Declaration
public static extern SQLite3.Result Prepare2(IntPtr db, string sql, int numBytes, out IntPtr stmt, IntPtr pzTail)
Parameters
Returns
Reset(IntPtr)
Declaration
public static extern SQLite3.Result Reset(IntPtr stmt)
Parameters
| Type |
Name |
Description |
| IntPtr |
stmt |
|
Returns
SetDirectory(UInt32, String)
Declaration
public static extern int SetDirectory(uint directoryType, string directoryPath)
Parameters
| Type |
Name |
Description |
| UInt32 |
directoryType |
|
| String |
directoryPath |
|
Returns
Shutdown()
Declaration
public static extern SQLite3.Result Shutdown()
Returns
Step(IntPtr)
Declaration
public static extern SQLite3.Result Step(IntPtr stmt)
Parameters
| Type |
Name |
Description |
| IntPtr |
stmt |
|
Returns