public static string GenerateFilterCondition(QueryDateChronologicalComparisons comparison, DateTime date, bool useOnlyTicks = false) { var key = ""; var queryComparison = QueryComparisons.Equal; switch (comparison) { case QueryDateChronologicalComparisons.After: key = RowKeysHelper.CreateChronologicalKeyStart(date.AddTicks(1), useOnlyTicks); queryComparison = QueryComparisons.GreaterThan; break; case QueryDateChronologicalComparisons.AfterOrEqual: key = RowKeysHelper.CreateChronologicalKeyStart(date, useOnlyTicks); queryComparison = QueryComparisons.GreaterThan; break; case QueryDateChronologicalComparisons.Before: queryComparison = QueryComparisons.LessThan; key = RowKeysHelper.CreateChronologicalKeyStart(date, useOnlyTicks); break; case QueryDateChronologicalComparisons.BeforeOrEqual: queryComparison = QueryComparisons.LessThan; key = RowKeysHelper.CreateChronologicalKeyStart(date.AddTicks(1), useOnlyTicks); break; } return(TableQuery.GenerateFilterCondition("RowKey", queryComparison, key)); }
public static string GenerateFilterCondition(QueryDateChronologicalComparisons comparison, DateTime date) { var key = ""; var queryComparison = QueryComparisons.Equal; switch (comparison) { case QueryDateChronologicalComparisons.After: key = RowKey.CreateChronologicalKeyStart(date.AddTicks(1)); queryComparison = QueryComparisons.GreaterThan; break; case QueryDateChronologicalComparisons.AfterOrEqual: key = RowKey.CreateChronologicalKeyStart(date); queryComparison = QueryComparisons.GreaterThan; break; case QueryDateChronologicalComparisons.Before: queryComparison = QueryComparisons.LessThan; key = RowKey.CreateChronologicalKeyStart(date); break; case QueryDateChronologicalComparisons.BeforeOrEqual: queryComparison = QueryComparisons.LessThan; key = RowKey.CreateChronologicalKeyStart(date.AddTicks(1)); break; default: break; } return TableQuery.GenerateFilterCondition("RowKey", queryComparison, key); }