private static TableQuery <DynamicTableEntity> PrepareTableQuery(DateTimeOffset fromDate, DateTimeOffset toDate)
{
var fromFilter =
TableQuery.GenerateFilterCondition(
"PartitionKey",
QueryComparisons.GreaterThanOrEqual,
DateTimeOffsetTools.ToUnixTimeSecondsString(fromDate));
var toFilter =
TableQuery.GenerateFilterCondition(
"PartitionKey",
QueryComparisons.LessThan,
DateTimeOffsetTools.ToUnixTimeSecondsString(toDate));
return(new TableQuery <DynamicTableEntity>().Where(
TableQuery.CombineFilters(fromFilter, TableOperators.And, toFilter)));
}
public string GeneratePartitionKey(DateTimeOffset time)
{
var unixSeconds = DateTimeOffsetTools.ToUnixTimeSeconds(time);
return(unixSeconds.ToString("D19"));
}
public string GenerateRowKey(DateTimeOffset time)
{
var now = DateTimeOffsetTools.ToUnixTimeMilliseconds(time);
return(now.ToString("D19") + "|" + Guid.NewGuid().ToString("N"));
}
