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