public void CountriesQueryAgentShouldReturnSpecificRecord() { using (var connection = new FTTConnection()) { var persistedCountry = connection.Countries.FirstOrDefault(c => "Philippines".Equals(c.Name, StringComparison.InvariantCultureIgnoreCase)); Assert.IsNotNull(persistedCountry); var queryAgent = new CountriesQueryAgent(connection); var retrievedCountry = queryAgent.Get(persistedCountry.CountryId); Assert.IsNotNull(retrievedCountry); } }
public void CountriesQueryAgentShouldReturnSpecificRecords() { using (var connection = new FTTConnection()) { var persistedCountries = connection.Countries .Where(c => c.Name.StartsWith("P")) .ToList(); Assert.IsTrue(persistedCountries.Any()); var queryAgent = new CountriesQueryAgent(connection); var retrievedCountries = queryAgent.Get("Name LIKE 'P%'", "Name"); Assert.IsNotNull(retrievedCountries); Assert.IsTrue(retrievedCountries.Any()); Assert.AreEqual(persistedCountries.Count, retrievedCountries.Count); } }