public void Select_MultiCondition(TestResult ret)
{
var ds = SqliteHelper.DB.GetTableRuntime().Where("id > 1").Where("and id < 3").ToSearch <Hero>();
ret.Equals(ds.Count, 1);
ret.Equals(ds[0].Id, 2);
}
public void MultiSelect_WhereOr(TestResult ret)
{
var ds = SqliteHelper.DB.GetTableRuntime().WhereOr("id", "=", 2, 3).ToSearch <Hero>();
ret.Equals(ds.Count, 2);
ret.Equals(ds[0].Id, 2);
ret.Equals(ds[1].Id, 3);
}
public void Select(TestResult ret)
{
//单条件查询
var ds = SqliteHelper.DB.GetTableRuntime().Where("id = 1").ToSearch <Hero>();
ret.Equals(ds.Count, 1);
ret.Equals(ds[0].Id, 1);
}
public void MultiSelect_WhereAnd(TestResult ret)
{
var ds = SqliteHelper.DB.GetTableRuntime().WhereAnd("id", "=", 1, 2).ToSearch <Hero>();
ret.Equals(ds.Count, 0);
}
