Exemplo n.º 1
0
        public void QueryTest2()
        {
            var db    = DatabaseHelper.GetHelper("test");
            var repos = new RepositoryDatabase <UserProfile>(db);

            var obj1 = repos.Get(1);
            var obj2 = repos.Get(x => x.Email == "*****@*****.**" && x.Sex == 1);

            var list1 = repos.GroupbyCount <int>(x => x.Sex, x => x.Id > 1 && x.Id < 1000);

            var list2 = repos.GroupbyMax <int, int>(x => x.Sex, x => x.Id, x => x.Id > 1 && x.Id < 1000);

            var list3 = repos.GroupbySum <int, int>(x => x.Sex, x => x.Id, x => x.Id > 1 && x.Id < 1000);

            var sumValue = repos.Sum <int>(x => x.Id, x => x.Id > 1 && x.Id < 1000 && x.Sex == 1);

            var maxValue = repos.Max <int>(x => x.Id, x => x.Id > 1 && x.Id < 1000 && x.Sex == 1);
        }