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