A Better Dynamic TableServiceEntity

30th of September, 2012 / / 3 Comments

When working with Azure Table Storage the recommended class to use is the provided TableServiceEntity class. This abstract class is designed to be inherited from in the data class which then requires the implementation of PartitionKey, RowKey and the addition of the attribute DataServiceKey which tells the underlying persistence system which properties map to those mandatory Azure Table Storage columns; like this:

[DataServiceKey(“PartitionKey”, “RowKey”)]
public class DomainClass : TableServiceEntity
{
   public DomainClass(): base(“PartitionKey”, “1”)
   {
   }
   public string PropertyOne { get; set; }
   public string PropertyTwo { get; set; }
} 

There are plenty of blogs on the .NET… [Keep reading] “A Better Dynamic TableServiceEntity”

Add oData Paging to Azure Table Storage

23rd of September, 2012 / / 2 Comments

After reading my previous blog, one of my Kloud colleagues raised a good point:

“What about continuation tokens?”

“Hmm, not sure, let me check. They should just pass through.”

Not so much.

Continuation tokens are used by the Azure Table Storage API as a way to move through a result set which may be larger than the maximum (1000) or has been limited using a $top parameter. Sure enough, a quick check shows that the previous solution is limited to 1000 rows in Excel.… [Keep reading] “Add oData Paging to Azure Table Storage”

Visualise Azure Table Storage with Excel and Fiddler

19th of September, 2012 / / 6 Comments

Today I came across an interesting problem;

I’m a big fan of Table Storage but its potential is yet to be realised because the tool support just isn’t a match for databases. We’ve got a solution which lays down a lot of data into Azure Table storage but the options to view that data is limited. There are plenty of available viewers including Visual Studio, Azure Storage Explorer and others. The problem with all of these viewers is they are limited to plain old tablular data views.… [Keep reading] “Visualise Azure Table Storage with Excel and Fiddler”