public void QueryTest3()
{
var db = DatabaseHelper.GetHelper("test");
var repos = new RepositoryDatabase <UserProfile>(db);
var list1 = repos.GetList(x => (object)x.Id == new[] { 1, 2, 3, 4, 5 });
//where Sex=1 and Name like 'test%'
var list2 = repos.GetList(x => x.Sex == 1 && x.Name.StartsWith("test"), 1, 10, x => x.Id, true);
var list3 = repos.GetList(x => x.Id > 1 && x.Id < 10 && (x.Sex == 1 || x.Sex == 2), 1, 10, x => x.Id, true, x => x.Id, true, x => x.Id, true);
Assert.IsNotNull(list1);
Assert.Greater(list1.Count, 0);
Assert.IsNotNull(list1);
Assert.Greater(list2.Count, 0);
}
