C# Class Mono.Data.Sqlite.SqliteBase

This internal class provides the foundation of Sqlite support. It defines all the abstract members needed to implement a Sqlite data provider, and inherits from SqliteConvert which allows for simple translations of string to and from Sqlite.
Inheritance: SqliteConvert, IDisposable
Show file Open project: rubenv/tripod Class Usage Examples

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
Close void
ColumnAffinity TypeAffinity
ColumnCount int
ColumnDatabaseName string
ColumnIndex int
ColumnMetaData void
ColumnName string
ColumnOriginalName string
ColumnTableName string
ColumnType string
CreateCollation void
CreateFunction void
FinalizeStatement void
GetBytes long
GetChars long
GetDateTime System.DateTime
GetDouble double
GetInt32 System.Int32
GetInt64 System.Int64
GetLastInsertRowId long
GetParamValueBytes long
GetParamValueDouble double
GetParamValueInt32 int
GetParamValueInt64 System.Int64
GetParamValueText string
GetParamValueType TypeAffinity
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
SetCommitHook void
SetRollbackHook void
SetTimeout void
SetUpdateHook void
SqliteBase System
SqliteLastError string
Step bool

Public Methods

Method Description
Dispose ( ) : void

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, Int32 value ) : void
Bind_Int64 ( SqliteStatement stmt, int index, System.Int64 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
Close ( ) : void

Closes the currently-open database.

After the database has been closed implemeters should call SqliteFunction.UnbindFunctions() to deallocate all interop allocated memory associated with the user-defined functions and collating sequences tied to the closed connection.

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
CreateCollation ( string strCollation, SqliteCollation func ) : void
CreateFunction ( string strFunction, int nArgs, SqliteCallback func, SqliteCallback funcstep, SqliteFinalCallback funcfinal ) : void
FinalizeStatement ( SqliteStatement stmt ) : void

Finalizes a prepared statement.
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
GetDateTime ( SqliteStatement stmt, int index ) : System.DateTime
GetDouble ( SqliteStatement stmt, int index ) : double
GetInt32 ( SqliteStatement stmt, int index ) : Int32
GetInt64 ( SqliteStatement stmt, int index ) : System.Int64
GetLastInsertRowId ( ) : long
GetParamValueBytes ( IntPtr ptr, int nDataOffset, byte bDest, int nStart, int nLength ) : long
GetParamValueDouble ( IntPtr ptr ) : double
GetParamValueInt32 ( IntPtr ptr ) : int
GetParamValueInt64 ( IntPtr ptr ) : System.Int64
GetParamValueText ( IntPtr ptr ) : string
GetParamValueType ( IntPtr ptr ) : TypeAffinity
GetText ( SqliteStatement stmt, int index ) : string
GetValue ( SqliteStatement stmt, int index, SqliteType typ ) : object
IsNull ( SqliteStatement stmt, int index ) : bool
Open ( string strFilename ) : void

Opens a database.

Implementers should call SqliteFunction.BindFunctions() and save the array after opening a connection to bind all attributed user-defined functions and collating sequences to the new connection.

Prepare ( string strSql, SqliteStatement previous, string &strRemain ) : SqliteStatement

Prepares a SQL statement for execution.
Reset ( SqliteStatement stmt ) : int

Resets a prepared statement so it can be executed again. If the error returned is SQLITE_SCHEMA, transparently attempt to rebuild the SQL statement and throw an error if that was not possible.
ReturnBlob ( IntPtr context, byte value ) : void
ReturnDouble ( IntPtr context, double value ) : void
ReturnError ( IntPtr context, string value ) : void
ReturnInt32 ( IntPtr context, Int32 value ) : void
ReturnInt64 ( IntPtr context, System.Int64 value ) : void
ReturnNull ( IntPtr context ) : void
ReturnText ( IntPtr context, string value ) : void
SetCommitHook ( SqliteCommitCallback func ) : void
SetRollbackHook ( SqliteRollbackCallback func ) : void
SetTimeout ( int nTimeoutMS ) : void

Sets the busy timeout on the connection. SqliteCommand will call this before executing any command.
SetUpdateHook ( SqliteUpdateCallback func ) : void
SqliteBase ( SqliteDateFormats fmt ) : System
SqliteLastError ( ) : string

Returns the text of the last error issued by Sqlite
Step ( SqliteStatement stmt ) : bool

Steps through a prepared statement.

Method Details

Dispose() public method

public Dispose ( ) : void
return void

Dispose() protected method

protected Dispose ( bool bDisposing ) : void
bDisposing bool
return void