public void SqlLiteTests() { using (var con = new System.Data.SQLite.SQLiteConnection()) { con.ConnectionString = "Data Source=:memory:"; con.Open(); var mydt = new System.Data.DataTable("testdt"); mydt.Columns.Add("one", typeof(int)); mydt.Columns.Add("two", typeof(int)); var data = new int[][] { new int[] { 1, 2 }, new int[] { 3, 4 }, new int[] { 5, 6 } }; foreach (var drow in data) { var row = mydt.NewRow(); row["one"] = drow[0]; row["two"] = drow[1]; mydt.Rows.Add(row); } con.LoadDataTable(mydt); var results = con.GetScalar<int>("select count(*) from testdt where one > 1"); Assert.AreEqual(2, results); } }