TitleIndex - SQLite3 Wrap ADO For .Net1.1 or Compact Wiki - SQLite3 Wrap ADO For .Net1.1 or C...

SQLite3 ADO Wrap For .Net 1.1 or Compact Framework

It is a library to use SQLite3 in .Net1.1 environment. Moreover, it has been adjusted that it is possible to use it also with a smart phone such as WindowsMobile. (The WindowsMobile version becomes it for .Net 1.0. )

The WindowsMobile(WindowsCE) version offered the user function and the user definition collating sequence function from Ver1.4.

1. Module necessary to use it

It made it for SQLite3 Ver.3.6.16 or more. - It is a confirmed operation by even 3.6.18.

Please pass sqlite3.dll, osqlite.dll, and SQLiteCSLib.dll through the application execution directory or the execution path. Please add SQLiteCSLib.dll to the reference to the project when developing with VisualStudio2003.Net.

Sqlite3.dll and osqlite.dll operate if it copies it onto Debug and Release.

Sqlite3.dll of the Windows version is registered in DownLoad->Precompiled Binaries For Windows of the head of the house site, and download it there, please.

Sqlite3.dll and osqlite.dll of the Windows CE version will offer only ARMV4, MIPS, and the SH4 edition.

2. Explanation of DLL

1) osqlite.dll

It is a run time library to have done the wrapping with simple C++ as for API of sqlite3.

2) SQLiteCSLib.dll

It becomes a run time library to have mounted the ADO interface of Net1.1. The following classes are offered.

SQLiteCSLib.SQLiteCommand 
SQLiteCSLib.SQLiteConnection 
SQLiteCSLib.SQLiteDataReader 
SQLiteCSLib.SQLiteException 
SQLiteCSLib.SQLiteParameter 
SQLiteCSLib.SQLiteParameterCollection 
SQLiteCSLib.SQLiteTransaction 
SQLiteCSLib.Inner.OSQLiteDBWrap 
SQLiteCSLib.Inner.OSQLiteStmtWrap 
SQLiteCSLib.Inner.OSQLiteFunc 
SQLiteCSLib.Inner.OSQLiteCollation 

Class SQLiteCSLib.Inner.OSQLiteDBWrap

It becomes rough of connected instances of the opening and the close, etc.

SQLiteCSLib.Inner.OSQLiteStmtWrap

It is a class that exists in the aggregate relationship for the transaction and OSQLiteDBWrap of the inquiry etc.

SQLiteCSLib.Inner.OSQLiteFunc

It is a class that offers the user-defined function function.

User function definition interface

SQLiteCSLib.Inner.IScalarCallUserFunction
SQLiteCSLib.Inner.IAggregateCallUserFunction

When the function is called to the class that mounts the above-mentioned and the interface, the mechanism being called is offered.

SQLiteCSLib.Inner.OSQLiteCollation

It is a class that offers the user definition collating sequence function.

User definition collating sequence interface

SQLiteCSLib.Inner.ICollationFunction

When the collating sequence (Only the text string :) is called to the class that mounts the above-mentioned and the interface, the mechanism being called is offered.

The user definition and the registration of the collating sequence function are offered to SQLiteConnection as a method.

3) Test application

The application to test the library is offered. Please refer to the TestApp project. It targets it for VisualStudio2003.