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