public void Test05ListCustomersViaServiceProductCategoryIdNonNullOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll <Product>().Computed().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list.Any(x => x.ProductCategoryIDNonNull != 0).ShouldEqual(true); } }
public void Test02ListSalesOrdersViaServiceOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll<ListSalesOrderDto>().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list[0].CustomerCompanyName.ShouldNotEqualNull(); } }
public void Test02ListSalesOrdersViaServiceOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll <ListSalesOrderDto>().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list[0].CustomerCompanyName.ShouldNotEqualNull(); } }
public void Test05ListCustomersViaServiceProductCategoryIdNonNullOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll<Product>().Computed().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list.Any( x => x.ProductCategoryIDNonNull != 0).ShouldEqual(true); } }
public void Test01ListOrderDetailViaServiceOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll<CrudSalesOrderDetailDto>().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list.First().ProductName.ShouldNotEqualNull(); } }
public void Test01ListOrderDetailViaServiceOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll <CrudSalesOrderDetailDto>().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list.First().ProductName.ShouldNotEqualNull(); } }
public void Check01ListGradesOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService <PostTagGrade, SimplePostTagGradeDto>(db); var firstGrade = db.PostTagGrades.Include(x => x.TagPart).Include(x => x.PostPart).First(); //ATTEMPT var list = service.GetAll().ToList(); //VERIFY list.Count().ShouldEqual(2); list.First().PostPartTitle.ShouldEqual(firstGrade.PostPart.Title); list.First().TagPartName.ShouldEqual(firstGrade.TagPart.Name); } }
public void Test01ListCustomersCheckIsOnSaleOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll<ListProductDto>().Computed().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list.Where( c => c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today))).All( x => x.IsOnSale).ShouldEqual(true); list.Where(c => !(c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today)))).All(x => x.IsOnSale).ShouldEqual(false); } }
public void Test01ListCustomersCheckIsOnSaleOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); //ATTEMPT var list = service.GetAll <ListProductDto>().Computed().ToList(); //VERIFY list.Count.ShouldBeGreaterThan(0); list.Where(c => c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today))).All(x => x.IsOnSale).ShouldEqual(true); list.Where(c => !(c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today)))).All(x => x.IsOnSale).ShouldEqual(false); } }
public void Check01ListGradesOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService<PostTagGrade, SimplePostTagGradeDto>(db); var firstGrade = db.PostTagGrades.Include(x => x.TagPart).Include(x => x.PostPart).First(); //ATTEMPT var list = service.GetAll().ToList(); //VERIFY list.Count().ShouldEqual(2); list.First().PostPartTitle.ShouldEqual(firstGrade.PostPart.Title); list.First().TagPartName.ShouldEqual(firstGrade.TagPart.Name); } }
public void Check02ListPostOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService <Post, SimplePostDto>(db); //ATTEMPT var list = service.GetAll().ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Title.ShouldEqual("First great post"); list.First().BloggerName.ShouldEqual("Jon Smith"); list.First().TagNames.ShouldEqual("Ugly post, Good post"); list.First().LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc); } }
public void Test02ListDirectPostOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService<Post>(db); var firstPost = db.Posts.Include(x => x.Blogger).First(); //ATTEMPT var list = service.GetAll().Include(x => x.Blogger).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Title.ShouldEqual(firstPost.Title); list.First().Blogger.Name.ShouldEqual(firstPost.Blogger.Name); list.First().Tags.ShouldEqual(null); } }
public void Check10ListNestedComputedOk() { using (var db = new SampleWebAppDb()) { //SETUP GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true; var service = new ListService <Tag, DelegateDecompileNeededPostDto>(db); var firstTag = db.Tags.Include(x => x.Posts).First(); //ATTEMPT var list = service.GetAll().OrderBy(x => x.TagId).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Name.ShouldEqual(firstTag.Name); list.First().Posts.First().BloggerNameAndEmail.ShouldNotEqualNull(); } }
public void Check02ListDirectPostOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService <Post>(db); var firstPost = db.Posts.Include(x => x.Blogger).First(); //ATTEMPT var list = service.GetAll().Include(x => x.Blogger).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Title.ShouldEqual(firstPost.Title); list.First().Blogger.Name.ShouldEqual(firstPost.Blogger.Name); list.First().Tags.ShouldEqual(null); } }
public void Check02NoComputedTakenInDtoDecomplierOnButNoComputedCopiedOk() { using (var db = new SampleWebAppDb()) { //SETUP GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true; var service = new ListService<Post, SimplePostDto>(db); var firstPost = db.Posts.Include(x => x.Blogger).OrderBy(x => x.PostId).First(); //ATTEMPT var list = service.GetAll().OrderBy(x => x.PostId).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Title.ShouldEqual(firstPost.Title); list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name); list.First().Tags.ShouldNotEqualNull(); } }
public void Check02ListBlogsCheckIncludesPostsOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService<Blog, SimpleBlogWithPostsDto>(db); //ATTEMPT var list = service.GetAll().ToList(); //VERIFY list.Count().ShouldEqual(2); var firstBlog = db.Blogs.Include(x => x.Posts).AsNoTracking().First(); list.First().Name.ShouldEqual(firstBlog.Name); list.First().EmailAddress.ShouldEqual(firstBlog.EmailAddress); list.First().Posts.ShouldNotEqualNull(); CollectionAssert.AreEquivalent(firstBlog.Posts.Select(x => x.PostId), list.First().Posts.Select(x => x.PostId)); } }
public void Test06ListCustomersPerformanceVer2Ok() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); var log = new List <string>(); db.Database.Log = log.Add; //ATTEMPT var query = service.GetAll <ListCustomerVer2Dto>().Where(x => x.HasBoughtBefore); var customers = query.ToList(); //VERIFY customers.Count.ShouldBeGreaterThan(0); customers[0].FullName.ShouldNotEqualNull(); customers.All(x => x.TotalAllOrders > 0).ShouldEqual(true); } }
public void Test02ListCustomersViaServiceNoTotalOrdersOk() { using (var db = new AdventureWorksLt2012()) { //SETUP var service = new ListService(db); var log = new List<string>(); db.Database.Log = log.Add; //ATTEMPT var query = service.GetAll<ListCustomerDto>().Where(x => !x.HasBoughtBefore); var customers = query.ToList(); //VERIFY customers.Count.ShouldBeGreaterThan(0); customers[0].FullName.ShouldNotEqualNull(); customers.All(x => x.TotalAllOrders == 0).ShouldEqual(true); } }
public void Check02ListBlogsCheckIncludesPostsOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService <Blog, SimpleBlogWithPostsDto>(db); //ATTEMPT var list = service.GetAll().ToList(); //VERIFY list.Count().ShouldEqual(2); var firstBlog = db.Blogs.Include(x => x.Posts).AsNoTracking().First(); list.First().Name.ShouldEqual(firstBlog.Name); list.First().EmailAddress.ShouldEqual(firstBlog.EmailAddress); list.First().Posts.ShouldNotEqualNull(); CollectionAssert.AreEquivalent(firstBlog.Posts.Select(x => x.PostId), list.First().Posts.Select(x => x.PostId)); } }
public void Check02NoComputedTakenInDtoDecomplierOnButNoComputedCopiedOk() { using (var db = new SampleWebAppDb()) { //SETUP GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true; var service = new ListService <Post, SimplePostDto>(db); var firstPost = db.Posts.Include(x => x.Blogger).OrderBy(x => x.PostId).First(); //ATTEMPT var list = service.GetAll().OrderBy(x => x.PostId).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Title.ShouldEqual(firstPost.Title); list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name); list.First().Tags.ShouldNotEqualNull(); } }
public void Check02ListPostDtoOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService(db); //ATTEMPT var query = service.GetAll<SimplePostDto>(); var list = query.ToList(); //VERIFY list.Count.ShouldEqual(3); list[0].Title.ShouldEqual("First great post"); list[0].BloggerName.ShouldEqual("Jon Smith"); list[0].TagNames.ShouldEqual("Ugly post, Good post"); list[0].LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc); } }
public void Check02ListPostOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService(db); var firstPost = db.Posts.Include(x => x.Blogger).First(); //ATTEMPT var query = service.GetAll<Post>().Include(x => x.Blogger); var list = query.ToList(); //VERIFY list.Count.ShouldEqual(3); list[0].Title.ShouldEqual(firstPost.Title); list[0].Blogger.Name.ShouldEqual(firstPost.Blogger.Name); list[0].Tags.ShouldEqual(null); } }
public async void Check02ListPostOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService <Post, DetailPostDtoAsync>(db); //ATTEMPT var list = await service.GetAll().ToListAsync(); //VERIFY list.Count().ShouldEqual(3); var firstPost = db.Posts.Include(x => x.Tags).ToList().First(x => x.PostId == list.First().PostId); list.First().Title.ShouldEqual(firstPost.Title); list.First().Content.ShouldEqual(firstPost.Content); list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name); list.First().TagNames.ShouldEqual("Ugly post, Good post"); list.First().LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc); } }
public void Check05ListComputedOk() { using (var db = new SampleWebAppDb()) { //SETUP GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true; var service = new ListService <Post, DelegateDecompilePostDto>(db); var firstPost = db.Posts.Include(x => x.Tags).First(); //ATTEMPT var list = service.GetAll().OrderBy(x => x.PostId).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Title.ShouldEqual(firstPost.Title); list.First().BloggerNameAndEmail.ShouldEndWith("nospam.com)"); list.First().TagNames.ShouldNotEqualNull(); CollectionAssert.AreEqual(firstPost.Tags.Select(x => x.Name), list.First().TagNames); } }
public void Check05ListComputedOk() { using (var db = new SampleWebAppDb()) { //SETUP GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true; var service = new ListService<Post, DelegateDecompilePostDto>(db); var firstPost = db.Posts.Include(x => x.Tags).First(); //ATTEMPT var list = service.GetAll().OrderBy(x => x.PostId).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Title.ShouldEqual(firstPost.Title); list.First().BloggerNameAndEmail.ShouldEndWith("nospam.com)"); list.First().TagNames.ShouldNotEqualNull(); CollectionAssert.AreEqual(firstPost.Tags.Select(x => x.Name), list.First().TagNames); } }
public void Check08UpdateWithListDtoBad() { using (var db = new SampleWebAppDb()) { //SETUP var listService = new ListService <Post, SimplePostDto>(db); var firstPostUntracked = listService.GetAll().First(); var service = new UpdateService <Post, SimplePostDto>(db); //ATTEMPT firstPostUntracked.Title = "Can't I ask a question?"; var status = service.Update(firstPostUntracked); firstPostUntracked.LogSpecificName("End"); //VERIFY status.IsValid.ShouldEqual(false); status.Errors.Count.ShouldEqual(1); status.Errors[0].ErrorMessage.ShouldEqual("Sorry, but you can't ask a question, i.e. the title can't end with '?'."); } }
public void Check10ListNestedComputedOk() { using (var db = new SampleWebAppDb()) { //SETUP GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true; var service = new ListService<Tag, DelegateDecompileNeededPostDto>(db); var firstTag = db.Tags.Include(x => x.Posts).First(); //ATTEMPT var list = service.GetAll().OrderBy(x => x.TagId).ToList(); //VERIFY list.Count().ShouldEqual(3); list.First().Name.ShouldEqual(firstTag.Name); list.First().Posts.First().BloggerNameAndEmail.ShouldNotEqualNull(); } }
private static void RunCommand2(IGenericServicesDbContext db) { var service = new ListService(db); var list = service.GetAll <SimplePostDto>().ToList(); }
public IQueryable <TEntity> GetAll() { return(ListService.GetAll()); }
//===================================================== //now the generic versions public static void ListGSelectDirect <T>(this SampleWebAppDb db, int id) where T : class, new() { var service = new ListService(db); var num = service.GetAll <T>().ToList().Count; }
//===================================================== //now the self-selecting public static void ListGenericDirect <T>(this SampleWebAppDb db, int id) where T : class { var service = new ListService <T>(db); var num = service.GetAll().ToList().Count; }
public static async Task ListGSelectDirectAsync <T>(this SampleWebAppDb db, int id) where T : class, new() { var service = new ListService(db); var list = await service.GetAll <T>().ToListAsync(); }
public void Check02ListPostOk() { using (var db = new SampleWebAppDb()) { //SETUP var service = new ListService<Post, DetailPostDto>(db); //ATTEMPT var list = service.GetAll().ToList(); //VERIFY list.Count().ShouldEqual(3); var firstPost = db.Posts.Include(x => x.Tags).ToList().First(x => x.PostId == list.First().PostId); list.First().Title.ShouldEqual(firstPost.Title); list.First().Content.ShouldEqual(firstPost.Content); list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name); list.First().TagNames.ShouldEqual("Ugly post, Good post"); list.First().LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc); } }
public void Check09UpdateWithListDtoBad() { using (var db = new SampleWebAppDb()) { //SETUP var listService = new ListService<Post, SimplePostDto>(db); var firstPostUntracked = listService.GetAll().First(); var service = new UpdateService<Post, SimplePostDto>(db); //ATTEMPT firstPostUntracked.Title = "Can't I ask a question?"; var status = service.Update(firstPostUntracked); firstPostUntracked.LogSpecificName("End"); //VERIFY status.IsValid.ShouldEqual(false); status.Errors.Count.ShouldEqual(1); status.Errors[0].ErrorMessage.ShouldEqual("Sorry, but you can't ask a question, i.e. the title can't end with '?'."); } }
public static void ListPostGenericViaDto(this SampleWebAppDb db, int id) { var service = new ListService <Post, SimplePostDto>(db); var num = service.GetAll().ToList().Count; }
private static void RunCommand2(IGenericServicesDbContext db) { var service = new ListService(db); var list = service.GetAll<SimplePostDto>().ToList(); }
public static void ListPostGSelectViaDto(this SampleWebAppDb db, int id) { var service = new ListService(db); var num = service.GetAll <SimplePostDto>().ToList().Count; }
public static async Task ListGenericDirectAsync <T>(this SampleWebAppDb db, int id) where T : class { var service = new ListService <T>(db); var list = await service.GetAll().ToListAsync(); }
public static async Task ListPostGSelectViaDtoAsync(this SampleWebAppDb db, int id) { var service = new ListService(db); var list = await service.GetAll <SimplePostDto>().ToListAsync(); }