Beispiel #1
0
        public void TestMethod1()
        {
            var             dbContext      = new DanwuDbContext();
            var             context        = new EntityFrameworkRepositoryContext();
            var             unitOfWork     = new EntityFrameworkUnitOfWork(dbContext);
            IUserRepository userRepository = new UserRepository(context);

            userRepository.Create(new User()
            {
                UserName      = "******",
                NickName      = "坏坏男孩",
                RealName      = "吴丹",
                PhoneNum      = "18916765826",
                Email         = "*****@*****.**",
                Status        = UserStatus.Enabled,
                PassWord      = "******",
                RegisterTime  = DateTime.Now,
                LastLogonTime = DateTime.Now
            });
            userRepository.Create(new User()
            {
                UserName      = "******",
                NickName      = "坏坏男孩1",
                RealName      = "吴丹1",
                PhoneNum      = "18916765000",
                Email         = "*****@*****.**",
                Status        = UserStatus.Disabled,
                PassWord      = "******",
                RegisterTime  = DateTime.Now,
                LastLogonTime = DateTime.Now
            });

            var result = context.Commit();
            //var result = unitOfWork.Commit();
        }
        public void PagingTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var repository = repositoryContext.GetRepository <int, Customer>();
                var customers  = Customer.CreateMany(21);
                foreach (var customer in customers)
                {
                    repository.Add(customer);
                }
                repositoryContext.Commit();

                var idList = customers.OrderBy(x => x.Email).Select(x => x.Id).Skip(5).Take(5).ToList();

                var pagedResult = repository.FindAll(new SortSpecification <int, Customer> {
                    { x => x.Email, SortOrder.Ascending }
                }, 2, 5);

                Assert.Equal(21, pagedResult.TotalRecords);
                Assert.Equal(5, pagedResult.TotalPages);
                Assert.Equal(2, pagedResult.PageNumber);
                Assert.Equal(5, pagedResult.PageSize);
                Assert.True(CompareIds(idList, pagedResult.As <int, Customer>().Select(x => x.Id).ToList()));
            }
        }
        public void Paging2Test()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var repository = repositoryContext.GetRepository <int, Customer>();
                var customers  = Customer.CreateMany(1000);
                foreach (var customer in customers)
                {
                    repository.Add(customer);
                }
                repositoryContext.Commit();

                var selectedCustomers = customers.Where(x => x.Id > 20000000).OrderByDescending(x => x.Id);
                var idList            = selectedCustomers.Select(x => x.Id).Skip(15).Take(15).ToList();
                var totalRecords      = selectedCustomers.Count();
                var totalPages        = (totalRecords + 14) / 15;

                var pagedResult = repository.FindAll(c => c.Id > 20000000,
                                                     new SortSpecification <int, Customer> {
                    { x => x.Id, SortOrder.Descending }
                }, 2, 15);

                Assert.Equal(totalRecords, pagedResult.TotalRecords);
                Assert.Equal(totalPages, pagedResult.TotalPages);
                Assert.Equal(2, pagedResult.PageNumber);
                Assert.Equal(15, pagedResult.PageSize);
                Assert.True(CompareIds(idList, pagedResult.As <int, Customer>().Select(x => x.Id).ToList()));
            }
        }
 public void GetBookseller()
 {
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new BooksellerRepository(uow);
     var result = repo.GetAll();
     Assert.IsTrue(result.Count() > 0);
 }
Beispiel #5
0
        public void TestMethod1()
        {
            var dbContext = new DanwuDbContext();
            var context = new EntityFrameworkRepositoryContext();
            var unitOfWork = new EntityFrameworkUnitOfWork(dbContext);
            IUserRepository userRepository = new UserRepository(context);
            userRepository.Create(new User()
            {
                UserName = "******",
                NickName = "坏坏男孩",
                RealName = "吴丹",
                PhoneNum = "18916765826",
                Email = "*****@*****.**",
                Status = UserStatus.Enabled,
                PassWord = "******",
                RegisterTime = DateTime.Now,
                LastLogonTime = DateTime.Now
            });
            userRepository.Create(new User()
            {
                UserName = "******",
                NickName = "坏坏男孩1",
                RealName = "吴丹1",
                PhoneNum = "18916765000",
                Email = "*****@*****.**",
                Status = UserStatus.Disabled,
                PassWord = "******",
                RegisterTime = DateTime.Now,
                LastLogonTime = DateTime.Now
            });

            var result = context.Commit();
            //var result = unitOfWork.Commit();
        }
        public void FindAllWithSortTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var repository = repositoryContext.GetRepository <int, Customer>();
                var customers  = Customer.CreateMany(500);

                foreach (var cust in customers)
                {
                    repository.Add(cust);
                }
                repositoryContext.Commit();

                var sorted = customers.OrderBy(x => x.Email).OrderByDescending(x => x.Name).ToList();

                var result = repository.FindAll(x => true, new SortSpecification <int, Customer> {
                    { _ => _.Email, SortOrder.Ascending }, { _ => _.Name, SortOrder.Descending }
                }).ToList();

                bool match = true;
                var  total = sorted.Count();
                for (var i = 0; i < total; i++)
                {
                    if (sorted[i].Email != result[i].Email || sorted[i].Name != result[i].Name)
                    {
                        match = false;
                        break;
                    }
                }

                Assert.True(match);
            }
        }
Beispiel #7
0
 public void TaskRecord_Test()
 {
     using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
     {
         var menus = repositoryContext.Context.Set <TaskRecord>().ToList();
         Assert.IsNotNull(menus);
     }
 }
 public void DbContext_Test()
 {
     using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
     {
         var reportGroups = repositoryContext.Context.Set <ReportGroup>().ToList();
         Assert.IsNotNull(reportGroups);
     }
 }
Beispiel #9
0
        public void GetTbmisUserWithRole()
        {
            IRepositoryContext uow = new EntityFrameworkRepositoryContext();
            var repo = new TbmisUserRepository(uow);
            var user = repo.First(t => t.UserName == "46010");

            Assert.IsTrue(user.IsInRole("教师"));
        }
Beispiel #10
0
        public void GetProfessionalClass()
        {
            IRepositoryContext uow = new EntityFrameworkRepositoryContext();
            var repo   = new ProfessionalClassRepository(uow);
            var result = repo.GetAll();

            Assert.IsTrue(result.Count() > 0);
        }
Beispiel #11
0
        public void GetStorage()
        {
            IRepositoryContext uow = new EntityFrameworkRepositoryContext();
            var repo   = new StorageRepository(uow);
            var result = repo.GetAll();

            Assert.IsTrue(result.Count() == 0);
        }
Beispiel #12
0
        public void GetStudentReleaseRecord()
        {
            IRepositoryContext uow = new EntityFrameworkRepositoryContext();
            var repo   = new StudentReleaseRecordRepository(uow);
            var result = repo.GetAll();

            Assert.IsTrue(result.Count() > 0);
        }
Beispiel #13
0
        public void GetTbmisUser()
        {
            IRepositoryContext uow = new EntityFrameworkRepositoryContext();
            var repo   = new TbmisUserRepository(uow);
            var result = repo.GetAll();

            Assert.IsTrue(result.Count() > 0);
        }
Beispiel #14
0
 public void DbContext_Test()
 {
     using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
     {
         var users = repositoryContext.Context.Set <Tenant>().ToList();
         Assert.IsNotNull(users);
     }
 }
Beispiel #15
0
 public void DbContext_Test()
 {
     using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
     {
         var actions = repositoryContext.Context.Set <Actions>().ToList();
         Assert.IsNotNull(actions);
     }
 }
Beispiel #16
0
 public void AttachmentTopic_Test()
 {
     using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
     {
         var menus = repositoryContext.Context.Set <AttachmentTopic>().ToList();
         Assert.IsNotNull(menus);
     }
 }
Beispiel #17
0
        public void TestMethod2() {
            var dbContext = new DanwuDbContext();
            var context = new EntityFrameworkRepositoryContext();
            var unitOfWork = new EntityFrameworkUnitOfWork(dbContext);
            IUserRepository userRepository = new UserRepository(context);
            var users = userRepository.QueryAll();

            //users=userRepository.QueryBy(
        }
Beispiel #18
0
        public void TestGetEntityList()
        {
            var context = new EntityFrameworkRepositoryContext();
            var pro     = new ProductRepository(context);

            var sp  = new ExpressionSpecification <Product>(p => p.UnitPrice > 20);
            var res = pro.GetEntityList(sp, 1, 2);

            Assert.IsTrue(true);
        }
Beispiel #19
0
        public void TestMethod2()
        {
            var             dbContext      = new DanwuDbContext();
            var             context        = new EntityFrameworkRepositoryContext();
            var             unitOfWork     = new EntityFrameworkUnitOfWork(dbContext);
            IUserRepository userRepository = new UserRepository(context);
            var             users          = userRepository.QueryAll();

            //users=userRepository.QueryBy(
        }
        public void DbContext_Test()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
            {
                var userRoles = repositoryContext.Context.Set <UserRole>().ToList();
                repositoryContext.Context.Dispose();

                Assert.IsNotNull(userRoles);
            }
        }
Beispiel #21
0
        public void TestGetProducts()
        {
            var context = new EntityFrameworkRepositoryContext();
            var pro     = new ProductRepository(context);

            var service = new Implementation.ProductService(pro);

            var list = service.GetProducts();

            Assert.IsNotNull(list);
        }
Beispiel #22
0
 public AdminService(DbContext erpDbContext, ICacheManager cacheManager = null)
 {
     _cacheManager           = cacheManager;
     _repositoryContext      = new EntityFrameworkRepositoryContext(erpDbContext);
     _productRepository      = new EntityFrameworkRepository <Product>(_repositoryContext);
     _productTagRepository   = new EntityFrameworkRepository <ProductTag>(_repositoryContext);
     _productImageRepository = new EntityFrameworkRepository <ProductImage>(_repositoryContext);
     _tagRepository          = new EntityFrameworkRepository <Tag>(_repositoryContext);
     _attachmentRepository   = new EntityFrameworkRepository <Attachment>(_repositoryContext);
     _categoryRepository     = new EntityFrameworkRepository <Category>(_repositoryContext);
 }
Beispiel #23
0
        public void GetStudentDeclarationJiaoWuByRepo()
        {
            //IUnitOfWork uow = new TbMisUnitOfWork();
            IRepositoryContext uow = new EntityFrameworkRepositoryContext();
            var repo   = new StudentDeclarationJiaoWuRepository(uow);
            var result = repo.GetAll();

            //Find(t => t.SchoolYearTerm.Year == "2011-2012" && t.SchoolYearTerm.Term == "2");
            //.Where(t => t.CanSubscribe);
            Assert.IsTrue(result.Count() > 0);
        }
        public void DbContext2_Test()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
            {
                var reportFields = repositoryContext.Context.Set <ReportField>().ToList();
                var reportField  = reportFields.Single(f => f.ID == new Guid("40AE807E-0CA5-4BEC-ADF3-56DF30A313BB"));
                repositoryContext.Context.SaveChanges();

                Assert.IsNotNull(reportFields);
                Assert.IsNotNull(reportField);
            }
        }
        public void Save2AggregateRootsTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var customers  = Customer.CreateMany(2);
                var repository = repositoryContext.GetRepository <int, Customer>();
                customers.ToList().ForEach(customer => repository.Add(customer));
                repositoryContext.Commit();

                var customersCount = repository.FindAll().Count();

                Assert.Equal(2, customersCount);
            }
        }
        public void SaveAggregateRootTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var customer   = Customer.CreateOne(1, "Sunny Chen", "*****@*****.**");
                var repository = repositoryContext.GetRepository <int, Customer>();
                repository.Add(customer);
                repositoryContext.Commit();

                var customersCount = repository.FindAll().Count();

                Assert.Equal(1, customersCount);
            }
        }
 public void AddBookseller()
 {
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new BooksellerRepository(uow);
     var bookseller = new Bookseller { Contact = "张三", Name = "测试", Telephone = "123456" };
     repo.Add(bookseller);
     repo.Context.Commit();
     var result = repo.Single(t =>
         t.Contact == bookseller.Contact &&
         t.Name == bookseller.Name &&
         t.Telephone == bookseller.Telephone
         );
     Assert.IsNotNull(result.ID);
 }
        public void FindAllTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var repository = repositoryContext.GetRepository <int, Customer>();
                var customers  = Customer.CreateMany(1000);
                foreach (var cust in customers)
                {
                    repository.Add(cust);
                }
                repositoryContext.Commit();

                var result = repository.FindAll();

                Assert.Equal(1000, result.Count());
            }
        }
Beispiel #29
0
        public void AddBookseller()
        {
            IRepositoryContext uow = new EntityFrameworkRepositoryContext();
            var repo       = new BooksellerRepository(uow);
            var bookseller = new Bookseller {
                Contact = "张三", Name = "测试", Telephone = "123456"
            };

            repo.Add(bookseller);
            repo.Context.Commit();
            var result = repo.Single(t =>
                                     t.Contact == bookseller.Contact &&
                                     t.Name == bookseller.Name &&
                                     t.Telephone == bookseller.Telephone
                                     );

            Assert.IsNotNull(result.ID);
        }
        public void UpdateByKeyTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var customer   = Customer.CreateOne(1, "Sunny Chen", "*****@*****.**");
                var repository = repositoryContext.GetRepository <int, Customer>();
                repository.Add(customer);
                repositoryContext.Commit();

                customer.Email = "*****@*****.**";
                repository.UpdateByKey(1, customer);
                repositoryContext.Commit();

                var updatedCustomer = repository.FindByKey(1);

                Assert.Equal("*****@*****.**", updatedCustomer.Email);
            }
        }
        public void Initialize()
        {
            var context = new EntityFrameworkRepositoryContext(new BlogContext());
            WebLogs = new GenericRepository<WebLog>(context);

            var title = Guid.NewGuid().ToString();

            var user = new User { Name = "user " + title };
            var webLog = new WebLog { Title = webLogID, CreatedAt = DateTime.Now };
            var post = new Post { Title = postID, Text = "oi", CreatedAt = DateTime.Now, LastUpdatedAt = DateTime.Now, PublishedAt = DateTime.Now };

            webLog.Collaborators.Add(user);
            user.AddBlog(webLog);
            webLog.Posts.Add(post);
            post.WebLog = webLog;

            WebLogs.SaveOrUpdate(webLog);
        }
Beispiel #32
0
        static void CachePerformanceTest(Boolean cachingEnabled)
        {
            DateTime started = DateTime.Now;
            Int32 loopymax = 100000;
            EntityFrameworkRepositoryContext<TheoreticalEntities> context
                = new EntityFrameworkRepositoryContext<TheoreticalEntities>();
            OrderDataMapBlock blocky;

            for (Int32 i = 0; i < loopymax; i++)
            {
                blocky = new OrderDataMapBlock();
                //blocky.Context = context;
                blocky.CachingEnabled = cachingEnabled;

                blocky.TouchDataMap();
            }
            var stringy = cachingEnabled ? "(Caching)" : "(No caching)";
            Console.WriteLine("Time to complete" + stringy + ": " + DateTime.Now.Subtract(started).TotalSeconds.ToString());
        }
Beispiel #33
0
        public void TestMethod1()
        {
            var context = new EntityFrameworkRepositoryContext();
            var pro     = new ProductRepository(context);

            var entity = new Product()
            {
                Name        = "TEST",
                Description = "TEST  Description",
                UnitPrice   = 15.00M,
                IsNew       = true,
                ImageUrl    = "www.tujia.com"
            };

            pro.Add(entity);

            //context.Commit();

            // int x = 0;
        }
        public void FindAllWithPredicateTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var repository = repositoryContext.GetRepository <int, Customer>();
                var customers  = Customer.CreateMany(500);

                foreach (var cust in customers)
                {
                    repository.Add(cust);
                }
                repositoryContext.Commit();

                var subset = customers.Where(x => x.Id > 1000000);

                var result = repository.FindAll(x => x.Id > 1000000);

                Assert.Equal(subset.Count(), result.Count());
            }
        }
        public void AddNavigationPropertyTest()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new SalesContext()))
            {
                var repository = repositoryContext.GetRepository <int, Customer>();
                var customer   = Customer.CreateOne();
                var id         = customer.Id;
                customer.Addresses = new List <Address> {
                    new Address {
                        Country = "China", State = "SH", City = "Shanghai", Street = "SF", ZipCode = "200000", Id = 1
                    }
                };
                repository.Add(customer);

                repositoryContext.Commit();

                var retrieved = repository.FindByKey(id);

                Assert.Single(retrieved.Addresses);
            }
        }
        public void DbContextRemoveField_Test()
        {
            using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms")))
            {
                var report =
                    repositoryContext.Context.Set <Report>().Include(r => r.Fields)
                    .Single(r => r.ID == new Guid("E84B3AE8-F47B-4012-9E9F-8DEC13FFC096"));

                var reportField = (
                    from field in report.Fields
                    where field.ID == new Guid("40AE807E-0CA5-4BEC-ADF3-56DF30A313BB")
                    select field
                    ).Single();

                report.Fields.Remove(reportField);
                repositoryContext.Context.SaveChanges();

                Assert.IsNotNull(report);
                Assert.IsNotNull(report.Fields);
            }
        }
 public void GetStorage()
 {
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new StorageRepository(uow);
     var result = repo.GetAll();
     Assert.IsTrue(result.Count() == 0);
 }
 public void GetTbmisUserWithRole()
 {
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new TbmisUserRepository(uow);
     var user = repo.First(t => t.UserName == "46010");
     Assert.IsTrue(user.IsInRole("教师"));
 }
 public void GetStudentReleaseRecord()
 {
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new StudentReleaseRecordRepository(uow);
     var result = repo.GetAll();
     Assert.IsTrue(result.Count() > 0);
 }
Beispiel #40
0
        static void DataMapBlockOdd()
        {
            try
            {
                OrderPocoDataMapBlock dataMapBlock = new OrderPocoDataMapBlock();
                EntityFrameworkRepositoryContext<TheoreticalEntities> context = new EntityFrameworkRepositoryContext<TheoreticalEntities>();
                dataMapBlock.Context = context;

                var findResult = dataMapBlock.TryFind(134);

                var addOrder = CreateNewOrderPoco();

                addOrder.Status = StatusEnum.Giggidy;

                //sl.Add(addOrder);
                dataMapBlock.Add(addOrder);
                context.SaveChanges();

                var addFindResult = dataMapBlock.TryFind(addOrder.MyId);

                //remove last and add a new one.
                addFindResult.MyOrderPocoItems.Remove(addFindResult.MyOrderPocoItems.Last());
                addFindResult.MyOrderPocoItems.Add(new OrderItemPoco()
                {
                    HasSerialNumber = false,
                    SalePrice = 1000M,
                    SerialNumber = "ADDEDITEM",
                    RenamedUpc = "ADDUPC",
                    ConcurrencyId = 0
                });

                dataMapBlock.Update(addFindResult);
                context.SaveChanges();

                addFindResult.OrderInformation.Last().TrackingNumber = "Giggidy";

                dataMapBlock.Update(addFindResult);
                context.SaveChanges();

                dataMapBlock.Delete(addFindResult);
                context.SaveChanges();
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
        }
Beispiel #41
0
        static void PerformanceAddMapperTest(Int32 numberOfInserts, Boolean proxiesEnabled, Boolean lazyEnabled)
        {
            DateTime started = DateTime.Now;
            Int32 loopymax = numberOfInserts;
            EntityFrameworkRepositoryContext<TheoreticalEntities> context = new EntityFrameworkRepositoryContext<TheoreticalEntities>();
            OrderPocoDataMapBlock blocky = new OrderPocoDataMapBlock();
            blocky.Context = context;

            context.DbContext.Configuration.ProxyCreationEnabled = proxiesEnabled;
            context.DbContext.Configuration.LazyLoadingEnabled = lazyEnabled;

            for (Int32 i = 0; i < loopymax; i++)
            {
                var newPoco = CreateNewOrderPoco();

                blocky.Add(newPoco);

                context.SaveChanges();
            }

            Console.WriteLine("Performance add datamapper time to complete:" + DateTime.Now.Subtract(started).TotalSeconds.ToString());
        }
Beispiel #42
0
        static void PerformanceUpdateMapperTest(Int32 numberOfInserts, Boolean proxiesEnabled, Boolean lazyEnabled)
        {
            DateTime started = DateTime.Now;
            Int32 loopymax = numberOfInserts;
            EntityFrameworkRepositoryContext<TheoreticalEntities> context = new EntityFrameworkRepositoryContext<TheoreticalEntities>();
            OrderPocoDataMapBlock blocky = new OrderPocoDataMapBlock();
            blocky.Context = context;

            context.DbContext.Configuration.ProxyCreationEnabled = proxiesEnabled;
            context.DbContext.Configuration.LazyLoadingEnabled = lazyEnabled;

            var updateTarget = blocky.FindFirst();

            for (Int32 i = 0; i < loopymax; i++)
            {
                updateTarget.OptionalNote = "Giggidy" + i.ToString();

                if (i % 2 == 0)
                {
                    updateTarget.OrderInformation.Add(new OrderInformationPoco()
                    {
                        TrackAmount = Convert.ToDecimal(i) * 100,
                        TrackDate = DateTime.Now,
                        TrackingNumber = "tracky" + i.ToString()
                    });
                }
                else
                {
                    var minDate = updateTarget.OrderInformation
                         .Where(a => a.OrderInformationId > 0).Min(a => a.OrderInformationId);

                    updateTarget.OrderInformation.Remove(updateTarget.OrderInformation
                        .Where(a => a.OrderInformationId == minDate).First());
                }

                blocky.Update(updateTarget);

                context.SaveChanges();
            }

            Console.WriteLine("Performance update datamapper time to complete:" + DateTime.Now.Subtract(started).TotalSeconds.ToString());
        }
 public void GetStudentDeclarationJiaoWuByRepo()
 {
     //IUnitOfWork uow = new TbMisUnitOfWork();
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new StudentDeclarationJiaoWuRepository(uow);
     var result = repo.GetAll();
     //Find(t => t.SchoolYearTerm.Year == "2011-2012" && t.SchoolYearTerm.Term == "2");
     //.Where(t => t.CanSubscribe);
     Assert.IsTrue(result.Count() > 0);
 }
 public void GetDepartment()
 {
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new DepartmentRepository(uow);
     var result = repo.GetAll();
     Assert.IsTrue(result.Count() > 0);
 }
 public void GetProfessionalClass()
 {
     IRepositoryContext uow = new EntityFrameworkRepositoryContext();
     var repo = new ProfessionalClassRepository(uow);
     var result = repo.GetAll();
     Assert.IsTrue(result.Count() > 0);
 }