public void SetUp() { var data = new List<TestObject> { new TestObject { PartitionKey = "Smith", RowKey = "Adam", Action = "2", Area = "area", DateAdded = new DateTimeOffset(new DateTime(2015, 01, 05)) }, new TestObject { PartitionKey = "Phillips", RowKey = "Steve", Action = "8", Area = "area", DateAdded = new DateTimeOffset(new DateTime(2015, 01, 05)) }, new TestObject { PartitionKey = "Phillips", RowKey = "Jenny", Action = "2", Area = "area3", DateAdded = new DateTimeOffset(new DateTime(2015, 01, 05)) }, new TestObject { PartitionKey = "Phillips", RowKey = "E", Action = "2", Area = "area", DateAdded = new DateTimeOffset(new DateTime(2015, 01, 09)) }, new TestObject { PartitionKey = "Jones", RowKey = "Quinton", Action = "2", Area = "area", DateAdded = new DateTimeOffset(new DateTime(2015, 01, 03)) } }; var partitionKeyFilter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Phillips"); var rowKeyFilter = TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.LessThan, "E"); var combineFilters = TableQuery.CombineFilters(partitionKeyFilter, TableOperators.And, rowKeyFilter); var rangeQuery = new TableQuery<TableEntity>().Where(combineFilters); _result = rangeQuery.Filter(data); }