public void RegionsQueryAgentShouldReturnSpecificRecord() { using (var connection = new FTTConnection()) { var persistedRegion = connection.Regions.FirstOrDefault(r => "NCR".Equals(r.Name, StringComparison.InvariantCultureIgnoreCase)); Assert.IsNotNull(persistedRegion); var queryAgent = new RegionsQueryAgent(connection); var retrievedRegion = queryAgent.Get(persistedRegion.RegionId); Assert.IsNotNull(retrievedRegion); } }
public void RegionsQueryAgentShouldReturnSpecificRecords() { using (var connection = new FTTConnection()) { var persistedRegions = connection.Regions .Where(r => r.Name.StartsWith("Region")) .ToList(); Assert.IsTrue(persistedRegions.Any()); var queryAgent = new RegionsQueryAgent(connection); var retrievedRegions = queryAgent.Get("regions.Name LIKE 'Region%'", "regions.Name"); Assert.IsNotNull(retrievedRegions); Assert.IsTrue(retrievedRegions.Any()); Assert.AreEqual(persistedRegions.Count, retrievedRegions.Count); } }