SQLite.SQLite3 Class Reference

Public Types
enum	Result : int {   OK = 0 , Error = 1 , Internal = 2 , Perm = 3 ,   Abort = 4 , Busy = 5 , Locked = 6 , NoMem = 7 ,   ReadOnly = 8 , Interrupt = 9 , IOError = 10 , Corrupt = 11 ,   NotFound = 12 , Full = 13 , CannotOpen = 14 , LockErr = 15 ,   Empty = 16 , SchemaChngd = 17 , TooBig = 18 , Constraint = 19 ,   Mismatch = 20 , Misuse = 21 , NotImplementedLFS = 22 , AccessDenied = 23 ,   Format = 24 , Range = 25 , NonDBFile = 26 , Notice = 27 ,   Warning = 28 , Row = 100 , Done = 101 }
enum	ExtendedResult : int {   IOErrorRead = (Result.IOError | (1 << 8)) , IOErrorShortRead = (Result.IOError | (2 << 8)) , IOErrorWrite = (Result.IOError | (3 << 8)) , IOErrorFsync = (Result.IOError | (4 << 8)) ,   IOErrorDirFSync = (Result.IOError | (5 << 8)) , IOErrorTruncate = (Result.IOError | (6 << 8)) , IOErrorFStat = (Result.IOError | (7 << 8)) , IOErrorUnlock = (Result.IOError | (8 << 8)) ,   IOErrorRdlock = (Result.IOError | (9 << 8)) , IOErrorDelete = (Result.IOError | (10 << 8)) , IOErrorBlocked = (Result.IOError | (11 << 8)) , IOErrorNoMem = (Result.IOError | (12 << 8)) ,   IOErrorAccess = (Result.IOError | (13 << 8)) , IOErrorCheckReservedLock = (Result.IOError | (14 << 8)) , IOErrorLock = (Result.IOError | (15 << 8)) , IOErrorClose = (Result.IOError | (16 << 8)) ,   IOErrorDirClose = (Result.IOError | (17 << 8)) , IOErrorSHMOpen = (Result.IOError | (18 << 8)) , IOErrorSHMSize = (Result.IOError | (19 << 8)) , IOErrorSHMLock = (Result.IOError | (20 << 8)) ,   IOErrorSHMMap = (Result.IOError | (21 << 8)) , IOErrorSeek = (Result.IOError | (22 << 8)) , IOErrorDeleteNoEnt = (Result.IOError | (23 << 8)) , IOErrorMMap = (Result.IOError | (24 << 8)) ,   LockedSharedcache = (Result.Locked | (1 << 8)) , BusyRecovery = (Result.Busy | (1 << 8)) , CannottOpenNoTempDir = (Result.CannotOpen | (1 << 8)) , CannotOpenIsDir = (Result.CannotOpen | (2 << 8)) ,   CannotOpenFullPath = (Result.CannotOpen | (3 << 8)) , CorruptVTab = (Result.Corrupt | (1 << 8)) , ReadonlyRecovery = (Result.ReadOnly | (1 << 8)) , ReadonlyCannotLock = (Result.ReadOnly | (2 << 8)) ,   ReadonlyRollback = (Result.ReadOnly | (3 << 8)) , AbortRollback = (Result.Abort | (2 << 8)) , ConstraintCheck = (Result.Constraint | (1 << 8)) , ConstraintCommitHook = (Result.Constraint | (2 << 8)) ,   ConstraintForeignKey = (Result.Constraint | (3 << 8)) , ConstraintFunction = (Result.Constraint | (4 << 8)) , ConstraintNotNull = (Result.Constraint | (5 << 8)) , ConstraintPrimaryKey = (Result.Constraint | (6 << 8)) ,   ConstraintTrigger = (Result.Constraint | (7 << 8)) , ConstraintUnique = (Result.Constraint | (8 << 8)) , ConstraintVTab = (Result.Constraint | (9 << 8)) , NoticeRecoverWAL = (Result.Notice | (1 << 8)) ,   NoticeRecoverRollback = (Result.Notice | (2 << 8)) }
enum	ConfigOption : int { SingleThread = 1 , MultiThread = 2 , Serialized = 3 }
enum	ColType : int {   Integer = 1 , Float = 2 , Text = 3 , Blob = 4 ,   Null = 5 }

Public Member Functions
static Result	Open ([MarshalAs(UnmanagedType.LPStr)] string filename, out IntPtr db)
static Result	Open ([MarshalAs(UnmanagedType.LPStr)] string filename, out IntPtr db, int flags, IntPtr zvfs)
static Result	Open (byte[] filename, out IntPtr db, int flags, IntPtr zvfs)
static Result	Open16 ([MarshalAs(UnmanagedType.LPWStr)] string filename, out IntPtr db)
static Result	EnableLoadExtension (IntPtr db, int onoff)
static Result	Close (IntPtr db)
static Result	Initialize ()
static Result	Shutdown ()
static Result	Config (ConfigOption option)
static int	SetDirectory (uint directoryType, string directoryPath)
static Result	BusyTimeout (IntPtr db, int milliseconds)
static int	Changes (IntPtr db)
static Result	Prepare2 (IntPtr db, [MarshalAs(UnmanagedType.LPStr)] string sql, int numBytes, out IntPtr stmt, IntPtr pzTail)
static Result	Step (IntPtr stmt)
static Result	Reset (IntPtr stmt)
static Result	Finalize (IntPtr stmt)
static long	LastInsertRowid (IntPtr db)
static IntPtr	Errmsg (IntPtr db)
static int	BindParameterIndex (IntPtr stmt, [MarshalAs(UnmanagedType.LPStr)] string name)
static int	BindNull (IntPtr stmt, int index)
static int	BindInt (IntPtr stmt, int index, int val)
static int	BindInt64 (IntPtr stmt, int index, long val)
static int	BindDouble (IntPtr stmt, int index, double val)
static int	BindText (IntPtr stmt, int index, [MarshalAs(UnmanagedType.LPWStr)] string val, int n, IntPtr free)
static int	BindBlob (IntPtr stmt, int index, byte[] val, int n, IntPtr free)
static int	ColumnCount (IntPtr stmt)
static IntPtr	ColumnName (IntPtr stmt, int index)
static ColType	ColumnType (IntPtr stmt, int index)
static int	ColumnInt (IntPtr stmt, int index)
static long	ColumnInt64 (IntPtr stmt, int index)
static double	ColumnDouble (IntPtr stmt, int index)
static IntPtr	ColumnText (IntPtr stmt, int index)
static IntPtr	ColumnText16 (IntPtr stmt, int index)
static IntPtr	ColumnBlob (IntPtr stmt, int index)
static int	ColumnBytes (IntPtr stmt, int index)
static ExtendedResult	ExtendedErrCode (IntPtr db)
static int	LibVersionNumber ()

Static Public Member Functions
static IntPtr	Prepare2 (IntPtr db, string query)
static string	GetErrmsg (IntPtr db)
static string	ColumnName16 (IntPtr stmt, int index)
static string	ColumnString (IntPtr stmt, int index)
static byte[]	ColumnByteArray (IntPtr stmt, int index)
static void	Copy< T > (IntPtr source, T[] destination, int startIndex, int length)
static ushort[]	ColumnUshortArray (IntPtr stmt, int index)
static bool[]	ColumnBoolArray (IntPtr stmt, int index)

Member Enumeration Documentation

ColType

enum SQLite.SQLite3.ColType : int

Enumerator
Integer
Float
Text
Blob
Null

ConfigOption

enum SQLite.SQLite3.ConfigOption : int

Enumerator
SingleThread
MultiThread
Serialized

ExtendedResult

enum SQLite.SQLite3.ExtendedResult : int

Enumerator
IOErrorRead
IOErrorShortRead
IOErrorWrite
IOErrorFsync
IOErrorDirFSync
IOErrorTruncate
IOErrorFStat
IOErrorUnlock
IOErrorRdlock
IOErrorDelete
IOErrorBlocked
IOErrorNoMem
IOErrorAccess
IOErrorCheckReservedLock
IOErrorLock
IOErrorClose
IOErrorDirClose
IOErrorSHMOpen
IOErrorSHMSize
IOErrorSHMLock
IOErrorSHMMap
IOErrorSeek
IOErrorDeleteNoEnt
IOErrorMMap
LockedSharedcache
BusyRecovery
CannottOpenNoTempDir
CannotOpenIsDir
CannotOpenFullPath
CorruptVTab
ReadonlyRecovery
ReadonlyCannotLock
ReadonlyRollback
AbortRollback
ConstraintCheck
ConstraintCommitHook
ConstraintForeignKey
ConstraintFunction
ConstraintNotNull
ConstraintPrimaryKey
ConstraintTrigger
ConstraintUnique
ConstraintVTab
NoticeRecoverWAL
NoticeRecoverRollback

Result

enum SQLite.SQLite3.Result : int

Enumerator
OK
Error
Internal
Perm
Abort
Busy
Locked
NoMem
ReadOnly
Interrupt
IOError
Corrupt
NotFound
Full
CannotOpen
LockErr
Empty
SchemaChngd
TooBig
Constraint
Mismatch
Misuse
NotImplementedLFS
AccessDenied
Format
Range
NonDBFile
Notice
Warning
Row
Done

Member Function Documentation

BindBlob()

int SQLite.SQLite3.BindBlob	(	IntPtr	stmt,
		int	index,
		byte[]	val,
		int	n,
		IntPtr	free )

BindDouble()

int SQLite.SQLite3.BindDouble	(	IntPtr	stmt,
		int	index,
		double	val )

BindInt()

int SQLite.SQLite3.BindInt	(	IntPtr	stmt,
		int	index,
		int	val )

BindInt64()

int SQLite.SQLite3.BindInt64	(	IntPtr	stmt,
		int	index,
		long	val )

BindNull()

int SQLite.SQLite3.BindNull	(	IntPtr	stmt,
		int	index )

BindParameterIndex()

int SQLite.SQLite3.BindParameterIndex	(	IntPtr	stmt,
		[MarshalAs(UnmanagedType.LPStr)] string	name )

BindText()

int SQLite.SQLite3.BindText	(	IntPtr	stmt,
		int	index,
		[MarshalAs(UnmanagedType.LPWStr)] string	val,
		int	n,
		IntPtr	free )

BusyTimeout()

Result SQLite.SQLite3.BusyTimeout	(	IntPtr	db,
		int	milliseconds )

Changes()

int SQLite.SQLite3.Changes

(

IntPtr

db

)

Close()

Result SQLite.SQLite3.Close

(

IntPtr

db

)

ColumnBlob()

IntPtr SQLite.SQLite3.ColumnBlob	(	IntPtr	stmt,
		int	index )

ColumnBoolArray()

bool[] SQLite.SQLite3.ColumnBoolArray ( IntPtr stmt, int index )

static

ColumnByteArray()

byte[] SQLite.SQLite3.ColumnByteArray ( IntPtr stmt, int index )

static

ColumnBytes()

int SQLite.SQLite3.ColumnBytes	(	IntPtr	stmt,
		int	index )

ColumnCount()

int SQLite.SQLite3.ColumnCount

(

IntPtr

stmt

)

ColumnDouble()

double SQLite.SQLite3.ColumnDouble	(	IntPtr	stmt,
		int	index )

ColumnInt()

int SQLite.SQLite3.ColumnInt	(	IntPtr	stmt,
		int	index )

ColumnInt64()

long SQLite.SQLite3.ColumnInt64	(	IntPtr	stmt,
		int	index )

ColumnName()

IntPtr SQLite.SQLite3.ColumnName	(	IntPtr	stmt,
		int	index )

ColumnName16()

string SQLite.SQLite3.ColumnName16 ( IntPtr stmt, int index )

static

ColumnString()

string SQLite.SQLite3.ColumnString ( IntPtr stmt, int index )

static

ColumnText()

IntPtr SQLite.SQLite3.ColumnText	(	IntPtr	stmt,
		int	index )

ColumnText16()

IntPtr SQLite.SQLite3.ColumnText16	(	IntPtr	stmt,
		int	index )

ColumnType()

ColType SQLite.SQLite3.ColumnType	(	IntPtr	stmt,
		int	index )

ColumnUshortArray()

ushort[] SQLite.SQLite3.ColumnUshortArray ( IntPtr stmt, int index )

static

Config()

Result SQLite.SQLite3.Config

(

ConfigOption

option

)

Copy< T >()

void SQLite.SQLite3.Copy< T > ( IntPtr source, T[] destination, int startIndex, int length )

static

Type Constraints

T

:

struct

EnableLoadExtension()

Result SQLite.SQLite3.EnableLoadExtension	(	IntPtr	db,
		int	onoff )

Errmsg()

IntPtr SQLite.SQLite3.Errmsg

(

IntPtr

db

)

ExtendedErrCode()

ExtendedResult SQLite.SQLite3.ExtendedErrCode

(

IntPtr

db

)

Finalize()

Result SQLite.SQLite3.Finalize

(

IntPtr

stmt

)

GetErrmsg()

string SQLite.SQLite3.GetErrmsg ( IntPtr db )

static

Initialize()

Result SQLite.SQLite3.Initialize

(

)

LastInsertRowid()

long SQLite.SQLite3.LastInsertRowid

(

IntPtr

db

)

LibVersionNumber()

int SQLite.SQLite3.LibVersionNumber

(

)

Open() [1/3]

Result SQLite.SQLite3.Open	(	[MarshalAs(UnmanagedType.LPStr)] string	filename,
		out IntPtr	db )

Open() [2/3]

Result SQLite.SQLite3.Open	(	[MarshalAs(UnmanagedType.LPStr)] string	filename,
		out IntPtr	db,
		int	flags,
		IntPtr	zvfs )

Open() [3/3]

Result SQLite.SQLite3.Open	(	byte[]	filename,
		out IntPtr	db,
		int	flags,
		IntPtr	zvfs )

Open16()

Result SQLite.SQLite3.Open16	(	[MarshalAs(UnmanagedType.LPWStr)] string	filename,
		out IntPtr	db )

Prepare2() [1/2]

Result SQLite.SQLite3.Prepare2	(	IntPtr	db,
		[MarshalAs(UnmanagedType.LPStr)] string	sql,
		int	numBytes,
		out IntPtr	stmt,
		IntPtr	pzTail )

Prepare2() [2/2]

IntPtr SQLite.SQLite3.Prepare2 ( IntPtr db, string query )

static

Reset()

Result SQLite.SQLite3.Reset

(

IntPtr

stmt

)

SetDirectory()

int SQLite.SQLite3.SetDirectory	(	uint	directoryType,
		string	directoryPath )

Shutdown()

Result SQLite.SQLite3.Shutdown

(

)

Step()

Result SQLite.SQLite3.Step

(

IntPtr

stmt

)