Skip to content
Syntactic sugar to make Azure development a little sweeter
Find file
Failed to load latest commit information.
AzureSugar fixed issue with not disposing of a web response Jul 30, 2012
packages fixed issue with not disposing of a web response Jul 30, 2012
.gitignore fixed issue with not disposing of a web response Jul 30, 2012
readme.markdown Update readme.markdown Feb 10, 2012



A lightweight .NET library which makes working with the Azure API easier.

Table Storage

Define a class which represents your table, and optionally supply a name using the 'TableName' attribute.

[TableName("Customers")]  // <- this is optional
public class Customer : TableServiceEntity
    public string Firstname { get; set; }
    public string Lastname { get; set; }

The AzureSugarTableContext allows you to create new customers easily:

using (var context = new AzureSugarTableContext(CloudStorageAccount.DevelopmentStorageAccount))
    var customer = context.Create<Customer>();
    customer.Firstname = "John";
    customer.Lastname = "Smith";

Primary keys (GUIDs) are automatially assigned. All commits are performed on disposal of the context.

It's just as easy to query the table:

using (var context = new AzureSugarTableContext(CloudStorageAccount.DevelopmentStorageAccount))
    foreach (var customer in (from c in context.Query<Customer>() where c.Firstname == "John" select c))

Dynamic Table Storage

Support is also available for using dynamic types (or dictionaries) to insert and query table storage.

First, create a context object:

var context = new DynamicTableContext("TableName", credentials);

Then inserting a record is easy using a dynamic object for example:

context.Insert(new { PartitionKey = "1", RowKey = "1", Value1 = "Hello", Value2 = "World" });

You can do the same with a dictionary:

var dictionary = new Dictionary<string, object>();
dictionary["PartitionKey"] = "2";
dictionary["RowKey"] = "2";
dictionary["Value3"] = "FooBar";

Retrieving an entity is striaght forward, just pass in the values for partition key and row key:

dynamic entity = content.Get("1", "1");

You can also pass in a query:

foreach (dynamic item in context.Query("Value1 eq 'Hello'"))


Queues are strongly typed. Let's say we are working with this class.

public class Foo
    public string Bar { get; set; }
    public string Baz { get; set; }

To push a message on to the queue, just do this:

var foo = new Foo { Bar = "bar", Baz = "baz" };
var queue = new AzureSugarQueue<Foo>(CloudStorageAccount.DevelopmentStorageAccount);

To pop a message from a queue, we just need to do this:

var queue = new AzureSugarQueue<Foo>(CloudStorageAccount.DevelopmentStorageAccount);
using (var message = queue.Pop())
    Foo foo = message.Content;
    // do something with foo

Your object is automatically deleted from the queue on the disposal of the message, however, you can have more control over this:

using (var message = queue.Pop(false))
    var foo2 = message.Content;

In this case, the message will only be deleted if 'VoteCommit' is called.

Queues also support IEnumerable, so you can apply linq expressions to the queue, and iterate over the messages:

foreach (var foo in queue.AsQueryable().Take(10).OrderBy(f => f.Bar))

The queue name is automatically derived from the type name 'Foo', however you can override this as well.


AzureSugar was written by Richard Astbury. For more information, or Azure consultancy, please contact two10 degrees:

Something went wrong with that request. Please try again.