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);
}
}
