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); }
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); } }
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); } }
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 GetProfessionalClass() { IRepositoryContext uow = new EntityFrameworkRepositoryContext(); var repo = new ProfessionalClassRepository(uow); var result = repo.GetAll(); Assert.IsTrue(result.Count() > 0); }
public void GetStorage() { IRepositoryContext uow = new EntityFrameworkRepositoryContext(); var repo = new StorageRepository(uow); var result = repo.GetAll(); Assert.IsTrue(result.Count() == 0); }
public void GetStudentReleaseRecord() { IRepositoryContext uow = new EntityFrameworkRepositoryContext(); var repo = new StudentReleaseRecordRepository(uow); var result = repo.GetAll(); Assert.IsTrue(result.Count() > 0); }
public void GetTbmisUser() { IRepositoryContext uow = new EntityFrameworkRepositoryContext(); var repo = new TbmisUserRepository(uow); var result = repo.GetAll(); Assert.IsTrue(result.Count() > 0); }
public void DbContext_Test() { using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms"))) { var users = repositoryContext.Context.Set <Tenant>().ToList(); Assert.IsNotNull(users); } }
public void DbContext_Test() { using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms"))) { var actions = repositoryContext.Context.Set <Actions>().ToList(); Assert.IsNotNull(actions); } }
public void AttachmentTopic_Test() { using (var repositoryContext = new EntityFrameworkRepositoryContext(new RmsDbContext("rms"))) { var menus = repositoryContext.Context.Set <AttachmentTopic>().ToList(); Assert.IsNotNull(menus); } }
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 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); }
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); } }
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); }
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); }
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()); } }
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); }
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()); }
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); } }
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()); } }
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()); }
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 GetDepartment() { IRepositoryContext uow = new EntityFrameworkRepositoryContext(); var repo = new DepartmentRepository(uow); var result = repo.GetAll(); Assert.IsTrue(result.Count() > 0); }