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