SQLite Project created by DM Company for easy working with SQLite db.You can download it on https://www.nuget.org/packages/DMSQLite/ or install via command Install-Package DMSQLite.
Here is examples for usage.
First of all create SQLite database and initialize it.
Example
 SQLite.SQLite.SQLiteCreateDB("DM.sqlite");
 SQLite.SQLite con = new SQLite.SQLite("DM.sqlite");
Then you need to create table.
Example
con.SQLiteCreateTable("CREATE TABLE DM(Id integer PRIMARY KEY AUTOINCREMENT, Note TEXT,Date TEXT);");
Then you can Insert row in your table with dictionary<string,object>
Example
  Dictionary<string, object> dic = new Dictionary<string, object>();
   dic.Add("Note", "SQlite from DM");
   dic.Add("Date", DateTime.Now);
 sql.SQLiteInsert(dic, "DM");
For more examples and usage you can view on our project called DM Journal

Last edited May 28, 2015 at 7:50 AM by DaveMk99, version 1