• Home
• Mono
• Data
• Sqlite
• SQLite3

C# Class Mono.Data.Sqlite.SQLite3

Show file Open project: kumpera/mono Class Usage Examples

Protected Properties

Property	Type	Description
_fileName	string
_functionsArray	Mono.Data.Sqlite.SqliteFunction[]
_poolVersion	int
_sql	SqliteConnectionHandle
_usePool	bool

Private Properties

Property	Type	Description
AggregateContext	System.IntPtr
AggregateCount	int
Bind_Blob	void
Bind_DateTime	void
Bind_Double	void
Bind_Int32	void
Bind_Int64	void
Bind_Null	void
Bind_ParamCount	int
Bind_ParamIndex	int
Bind_ParamName	string
Bind_Text	void
Cancel	void
ChangePassword	void
ClearPool	void
Close	void
ColumnAffinity	TypeAffinity
ColumnCount	int
ColumnDatabaseName	string
ColumnIndex	int
ColumnMetaData	void
ColumnName	string
ColumnOriginalName	string
ColumnTableName	string
ColumnType	string
ContextCollateCompare	int
ContextCollateCompare	int
CreateCollation	void
CreateFunction	void
GetBytes	long
GetChars	long
GetCollationSequence	Mono.Data.Sqlite.CollationSequence
GetCursorForTable	int
GetDateTime	System.DateTime
GetDouble	double
GetIndexColumnExtendedInfo	void
GetInt32	int
GetInt64	long
GetParamValueBytes	long
GetParamValueDouble	double
GetParamValueInt32	int
GetParamValueInt64	long
GetParamValueText	string
GetParamValueType	TypeAffinity
GetRowIdForCursor	long
GetText	string
GetValue	object
IsNull	bool
Open	void
Prepare	SqliteStatement
Reset	int
ReturnBlob	void
ReturnDouble	void
ReturnError	void
ReturnInt32	void
ReturnInt64	void
ReturnNull	void
ReturnText	void
SQLite3	System
SQLiteLastError	string
SetCommitHook	void
SetPassword	void
SetRollbackHook	void
SetTimeout	void
SetUpdateHook	void
Step	bool

Protected Methods

Method	Description
Dispose ( bool bDisposing ) : void

Private Methods

Method	Description
AggregateContext ( IntPtr context ) : IntPtr
AggregateCount ( IntPtr context ) : int
Bind_Blob ( SqliteStatement stmt, int index, byte blobData ) : void
Bind_DateTime ( SqliteStatement stmt, int index, System.DateTime dt ) : void
Bind_Double ( SqliteStatement stmt, int index, double value ) : void
Bind_Int32 ( SqliteStatement stmt, int index, int value ) : void
Bind_Int64 ( SqliteStatement stmt, int index, long value ) : void
Bind_Null ( SqliteStatement stmt, int index ) : void
Bind_ParamCount ( SqliteStatement stmt ) : int
Bind_ParamIndex ( SqliteStatement stmt, string paramName ) : int
Bind_ParamName ( SqliteStatement stmt, int index ) : string
Bind_Text ( SqliteStatement stmt, int index, string value ) : void
Cancel ( ) : void
ChangePassword ( byte newPasswordBytes ) : void
ClearPool ( ) : void
Close ( ) : void
ColumnAffinity ( SqliteStatement stmt, int index ) : TypeAffinity
ColumnCount ( SqliteStatement stmt ) : int
ColumnDatabaseName ( SqliteStatement stmt, int index ) : string
ColumnIndex ( SqliteStatement stmt, string columnName ) : int
ColumnMetaData ( string dataBase, string table, string column, string &dataType, string &collateSequence, bool &notNull, bool &primaryKey, bool &autoIncrement ) : void
ColumnName ( SqliteStatement stmt, int index ) : string
ColumnOriginalName ( SqliteStatement stmt, int index ) : string
ColumnTableName ( SqliteStatement stmt, int index ) : string
ColumnType ( SqliteStatement stmt, int index, TypeAffinity &nAffinity ) : string
ContextCollateCompare ( CollationEncodingEnum enc, IntPtr context, char c1, char c2 ) : int
ContextCollateCompare ( CollationEncodingEnum enc, IntPtr context, string s1, string s2 ) : int
CreateCollation ( string strCollation, SQLiteCollation func, SQLiteCollation func16 ) : void
CreateFunction ( string strFunction, int nArgs, bool needCollSeq, SQLiteCallback func, SQLiteCallback funcstep, SQLiteFinalCallback funcfinal ) : void
GetBytes ( SqliteStatement stmt, int index, int nDataOffset, byte bDest, int nStart, int nLength ) : long
GetChars ( SqliteStatement stmt, int index, int nDataOffset, char bDest, int nStart, int nLength ) : long
GetCollationSequence ( SqliteFunction func, IntPtr context ) : Mono.Data.Sqlite.CollationSequence
GetCursorForTable ( SqliteStatement stmt, int db, int rootPage ) : int
GetDateTime ( SqliteStatement stmt, int index ) : System.DateTime
GetDouble ( SqliteStatement stmt, int index ) : double
GetIndexColumnExtendedInfo ( string database, string index, string column, int &sortMode, int &onError, string &collationSequence ) : void
GetInt32 ( SqliteStatement stmt, int index ) : int
GetInt64 ( SqliteStatement stmt, int index ) : long
GetParamValueBytes ( IntPtr p, int nDataOffset, byte bDest, int nStart, int nLength ) : long
GetParamValueDouble ( IntPtr ptr ) : double
GetParamValueInt32 ( IntPtr ptr ) : int
GetParamValueInt64 ( IntPtr ptr ) : long
GetParamValueText ( IntPtr ptr ) : string
GetParamValueType ( IntPtr ptr ) : TypeAffinity
GetRowIdForCursor ( SqliteStatement stmt, int cursor ) : long
GetText ( SqliteStatement stmt, int index ) : string
GetValue ( SqliteStatement stmt, int index, Mono.Data.Sqlite.SQLiteType typ ) : object	Helper function to retrieve a column of data from an active statement.
IsNull ( SqliteStatement stmt, int index ) : bool
Open ( string strFilename, SQLiteOpenFlagsEnum flags, int maxPoolSize, bool usePool ) : void
Prepare ( SqliteConnection cnn, string strSql, SqliteStatement previous, uint timeoutMS, string &strRemain ) : SqliteStatement
Reset ( SqliteStatement stmt ) : int
ReturnBlob ( IntPtr context, byte value ) : void
ReturnDouble ( IntPtr context, double value ) : void
ReturnError ( IntPtr context, string value ) : void
ReturnInt32 ( IntPtr context, int value ) : void
ReturnInt64 ( IntPtr context, long value ) : void
ReturnNull ( IntPtr context ) : void
ReturnText ( IntPtr context, string value ) : void
SQLite3 ( SQLiteDateFormats fmt ) : System
SQLiteLastError ( ) : string
SetCommitHook ( SQLiteCommitCallback func ) : void
SetPassword ( byte passwordBytes ) : void
SetRollbackHook ( SQLiteRollbackCallback func ) : void
SetTimeout ( int nTimeoutMS ) : void
SetUpdateHook ( SQLiteUpdateCallback func ) : void
Step ( SqliteStatement stmt ) : bool

Method Details

Property Details