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);
}
}
