5pLuavee

1public class YesDatabase
2{
3    static object locker = new object ();
4
5    public SqliteConnection connection;
6
7    public string path; 
8
9    public YesDatabase (string dbPath)
10    {
11        var output = "";
12        path = dbPath;
13        // create the tables
14        bool exists = File.Exists (dbPath);
15
16        if (!exists) 
17        {
18            connection = new SqliteConnection ("Data Source=" + dbPath);
19
20            connection.Open ();
21
22            var ccommandsc = new[] {
23                "CREATE TABLE IF NOT EXISTS [Citems] (_id INTEGER PRIMARY KEY ASC, Cname NTEXT, Cnotes NTEXT, Ccat NTEXT);"
24            };
25            foreach (var commandc in ccommandsc) {
26                using (var d = connection.CreateCommand ()) {
27                    d.CommandText = commandc;
28                    var j = d.ExecuteNonQuery ();
29                }
30            }
31
32
33        } else 
34        {
35            // already exists, do nothing. 
36        }
37        Console.WriteLine (output);
38    }
39
40
41            Contact FromReaderc (SqliteDataReader r) {
42        var c = new Contact ();
43        c.ID = Convert.ToInt32 (r ["_id"]);
44        c.Cname = r ["Cname"].ToString ();
45        c.Cnotes = r ["Cnotes"].ToString ();
46        c.Ccat = r ["Ccat"].ToString ();
47        return c;  
48
49}