Create a new Cloud Service project called Chapter16.TableStorage, adding a single ASP.NET web role to it.

In the WebRole1 project, add a reference to System.Data.Services.Client.

Open the ServiceDefinition.csdef file, and add the following entry to the ConfigurationSettings section:

<Setting name="DataConnectionString" />

Open ServiceConfiguration.cscfg, and add the following entry to ConfigurationSettings:

<Setting name="DataConnectionString" value="UseDevelopmentStorage=true" />

Add a new class to the project called AzureDataServiceContext, and add the following using directives:

using Microsoft.WindowsAzure.StorageClient;
using Microsoft.WindowsAzure;

Now enter the following code in AzureDataServiceContext.cs:

public class AzureDataServiceContext : TableServiceContext
{
    public AzureDataServiceContext(string baseAddress,
                                   StorageCredentials credentials)
            : base(baseAddress, credentials)
    {
    }

    public IQueryable<Film> FilmTable
    {
        get
        {
            return this.CreateQuery<Film>("Films");
        }
    }
}

Add a new class to the project called Film with the following using directive:

using Microsoft.WindowsAzure.StorageClient;

Now add the following code to define the class:

public class Film : TableServiceEntity
{
    public int FilmID { get; set; }
    public string Title {get; set; }
}

Open Default.aspx.cs, and add the following using statements:

using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.ServiceRuntime;
using Microsoft.WindowsAzure.StorageClient;

Now enter the following code:

CloudStorageAccount.SetConfigurationSettingPublisher((configName, configSetter) =>
{
    // Provide the configSetter with the initial value
    configSetter(RoleEnvironment.GetConfigurationSettingValue(configName));
});

var storageAccount = CloudStorageAccount.FromConfigurationSetting("DataConnectionString");
var tableStorage = storageAccount.CreateCloudTableClient();
tableStorage.CreateTableIfNotExist("Films");

AzureDataServiceContext svc =
  new AzureDataServiceContext(storageAccount.TableEndpoint.ToString(),
                              storageAccount.Credentials);

Film f1 = new Film();
f1.FilmID = 777;
f1.Title = "Commando";
f1.Timestamp = System.DateTime.Now;
f1.PartitionKey = "UK";
f1.RowKey = Guid.NewGuid().ToString();

svc.AddObject("Films", f1);
svc.SaveChanges();
Film film = svc.FilmTable.Where(f => f.FilmID == 777).FirstOrDefault();

Response.Write(film.Title);

Press F5 to run your application, and you should see "Commando" printed out to the screen.