public MetricsTransactionsEntity[] GetMetrics(CloudStorageAccount storageAccount, DateTime startDateTimeUTC, DateTime endDateTimeUTC)
{
MetricsTransactionsTable table = new MetricsTransactionsTable(storageAccount,
storageAccount.Credentials);
//convert datetimes to partition keys
String startingPartitionKey = startDateTimeUTC.ToString(StorageResource.TransactionPrimaryKeyTimeFormat);
String endingPartitionKey = endDateTimeUTC.ToString(StorageResource.TransactionPrimaryKeyTimeFormat);
var query = from transactionsEntity in table.Queryable
where transactionsEntity.PartitionKey.CompareTo(startingPartitionKey) >= 0
&& transactionsEntity.PartitionKey.CompareTo(endingPartitionKey) <= 0
select transactionsEntity;
CloudTableQuery<MetricsTransactionsEntity> tableServiceQuery = query.AsTableServiceQuery();
MetricsTransactionsEntity[] metricsTransactionsEntities;
try
{
//execute query
metricsTransactionsEntities = tableServiceQuery.Execute().ToArray();
}
catch (Exception exception)
{
//TODO:log
throw;
}
return metricsTransactionsEntities;
}
public MetricsTransactionsEntity[] GetMetrics(CloudStorageAccount storageAccount, DateTime startDateTimeUTC, DateTime endDateTimeUTC)
{
MetricsTransactionsTable table = new MetricsTransactionsTable(storageAccount,
storageAccount.Credentials);
//convert datetimes to partition keys
String startingPartitionKey = startDateTimeUTC.ToString(StorageResource.TransactionPrimaryKeyTimeFormat);
String endingPartitionKey = endDateTimeUTC.ToString(StorageResource.TransactionPrimaryKeyTimeFormat);
var query = from transactionsEntity in table.Queryable
where transactionsEntity.PartitionKey.CompareTo(startingPartitionKey) >= 0 &&
transactionsEntity.PartitionKey.CompareTo(endingPartitionKey) <= 0
select transactionsEntity;
CloudTableQuery <MetricsTransactionsEntity> tableServiceQuery = query.AsTableServiceQuery();
MetricsTransactionsEntity[] metricsTransactionsEntities;
try
{
//execute query
metricsTransactionsEntities = tableServiceQuery.Execute().ToArray();
}
catch (Exception exception)
{
//TODO:log
throw;
}
return(metricsTransactionsEntities);
}