SQLiteNet is a C++ managed wrapper for SQLite. It was create by a company called "Red Loop" and then abandoned. One of the group members loaded the source into the files area (and the original is still there). I decided to use it for a project and then decided to change to add/modify a few bits. To stop any confusion with the original I have a web page http://www.geckoware.com.au/Content.aspx?Doc_id=1008#SQLite which you can download the source/assembly and a VB.NET sample application. These projects were developed using IDE 2003 version 7.1.3088.
SQLiteNet Object Model
Assembly SQLiteNET SQLiteNET.dll
Namespace SQLiteNET
-
Public Class Database DocumentationSqliteNetDatabase
Public Class SQLiteNet DocumentationSqliteNetSqliteNet
Public Class SQLiteException DocumentationSqliteNetSqliteException
Public Enum DB_DATA_TABLE_MODE As Integer DocumentationSqliteNetDbDataTableMode
Public Enum DB_EVENT_MODE As Integer DocumentationSqliteNetDbEventMode
Public Enum SQLITE_RESULTS DocumentationSqliteNetSqliteResults
Example
Dim DB As SQLiteNET.DataBase ' Define the object
Dim LocaLDataTable As DatATable 'Define a local datatable object
Try
DB = New SQLiteNET.DataBase("c:\dbfile.db") ' Create a new object
DB.Execute("Select * from SQLite_master") 'Execute a query
LocalDatATable = DB.DataTable
Catch ex As SQLiteNET.SQLiteException
MessageBox.Show(ex.ErrorCode)
End Try
DB.Close()
If you have any question regarding this object or it's use please check the source (it has comments) and if you want email me on vbsqlite.at.ag-software.com