public void SelectWithSpecification_EmptyCollection_ReturnsFalse() { string number = "12-xx-78"; Agreement agreement = TestDbContextHelper.AddAgreement(number); using (var repository = new AgreementRepository(new TestDbContext())) { var specification = new NumberSpecification(number); var result = repository.Select(specification); Assert.IsNotNull(result); } }
public async Task OnGetAsync_PopulatesThePageModel_WithAListOfProducts() { using (var context = new ApplicationDbContext(TestDbContextHelper.TestDbContextOptions())) { context.Products.Add(new Product { Name = "Product 1", Price = 99 }); context.Products.Add(new Product { Name = "Product 2", Price = 500 }); context.SaveChanges(); var pageModel = new IndexModel(context); await pageModel.OnGetAsync(); Assert.IsAssignableFrom <IList <Product> >(pageModel.Product); Assert.Equal(2, pageModel.Product.Count); } }
public void BulkInsertInTempTable_JoinAgreementOnIdentityTable_ReturnAgreement() { int agreementId = TestDbContextHelper.AddAgreement().Id; using (var dbContext = new TestDbContext()) { var repository = new TemporaryTableRepository(dbContext); var collection = new List <int> { agreementId, 0, -1, -2, -3 }; var query = repository.BulkInsertInTempTable(collection); var queryResult = query.ToList(); Assert.IsTrue(queryResult.Count == 5); var agreementRepository = new AgreementRepository(dbContext); var agreements = agreementRepository.QueryableSelect().Join(query, agreement => agreement.Id, identity => identity.Id, (agreement, identity) => agreement).ToList(); Assert.IsTrue(agreements.Count == 1); } }