Windows Azure Table Storage Tip

Create.cs

var account = CloudStorageAccount.FromConfigurationSetting("DataConnectionString");
CloudTableClient.CreateTablesFromModel(
    typeof(TableServiceContext),
    account.TableEndpoint.AbsoluteUri,
    account.Credentials);

Entities.cs

public class CustomerEntity : TableServiceEntity {

    public CustomerEntity()
        : base("_default", null) {
    }

    public string FirstName { get; set; }
    public string LastName { get; set; }

}

public class ProductEntity : TableServiceEntity {

    public ProductEntity()
        : base("_default", null) {

    }

    public string Name { get; set; }
    public int Price { get; set; }

}

public class OrderEntity : TableServiceEntity {

    public OrderEntity()
        : base("_default", null) {

    }

    public string ProductRowkey { get; set; }
    public string CustomerRowKey { get; set; }

}

Query.cs

var account = CloudStorageAccount.FromConfigurationSetting("DataConnectionString");
var context = new TableStorageContext(account.TableEndpoint.ToString(), account.Credentials);
var customer = context.Customers.SingleOrDefault(c => c.RowKey == "1234");

TableStorageContext.cs

public class TableStorageContext : TableServiceContext {

    private const string CustomersTable = "Customers";
    private const string ProductsTable = "Products";
    private const string OrdersTable = "Orders";

    public TableStorageContext(string baseAddress, StorageCredentials credentials)
        : base(baseAddress, credentials) {
    }

    public IQueryable<CustomerEntity> Customers {
        get {
            return this.CreateQuery(CustomersTable).Where(c => c.PartitionKey == "_default");
        }
    }

    public IQueryable<ProductEntity> Products {
        get {
            return this.CreateQuery(ProductsTable).Where(c => c.PartitionKey == "_default");
        }
    }

    public IQueryable<OrderEntity> Orders {
        get {
            return this.CreateQuery(OrdersTable).Where(c => c.PartitionKey == "_default");
        }
    }

    public void AddCustomer(CustomerEntity customer) {
        this.AddObject(CustomersTable, customer);
    }

    public void AddProduct(ProductEntity product) {
        this.AddObject(ProductsTable, product);
    }

    public void AddOrder(OrderEntity order) {
        this.AddObject(OrdersTable, order);
    }

}