9 simple steps to run your first Azure Table Program

Step 5:- Define partition and row key

The next step is to define the properties of the customer class. In the below figure we have defined two properties in the customer class customer code and customer name.

Every row in the table needs to be defined with a partition key and a unique row key. In the constructor we have initialized the partition key with a text "Customers" and the unique key is set to the current date time tick count.

Step 6:- Create your 'datacontext' class

The next step is to create your data context class which will insert the customer entity in to azure table storage. Below is the code snippet of the data context class.

The first noticeable thing is the constructor which takes in location of the credentials. The second is the 'Iqueryable' interface which is used by the cloud service to create tables in azure cloud service.



In the same data context we have created an 'AddCustomer' method which takes in the customer entity object and call's the 'AddObject' method of the data context to insert the customer entity data in to Azure tables.

Step 7:- Create the table structure on the 'onstart'

The next step is to create the table on the 'onstart' of the web role.



So open 'webrole.cs' file and put the below code on the 'onstart' event. The last code enclosed in curly brackets gets the configuration and creates table's structure.

Step 8:- Code your client

The final thing is to code the client. So below is the UI / ASPX file which we have created to insert the table entity values.



On the button click we need to consume the data context and the entity class.

So the first step is to get the configuration setting of the data connection.

// Gets the connection string
var customer = CloudStorageAccount.FromConfigurationSetting("DataConnectionString");

The next step is to pass these credentials to the data context class and create a object of the same.

// Create the customer datacontext object
var customerContext = new clsCustomerDataContext(customer.TableEndpoint.ToString(), customer.Credentials);

Flourish the entity object with data and pass it to the data context class to add the same in to tables.

// Create the entity object
clsCustomer objCustomer = new clsCustomer();
objCustomer.CustomerCode = txtCustomerCode.Text;
objCustomer.CustomerName = txtCustomerName.Text;
// Pass the entity object to the datacontext
customerContext.AddCustomer(objCustomer);

Finally we loop through the context customer entity collection to see if the customer is added in to the table.

//Loop through the records to see if the customer entity is inserted in the tabless
foreach (clsCustomer obj in customerContext.Customers)
{
Response.Write(obj.CustomerCode + " " + obj.CustomerName + "<br>");
}

Step 9:- Run your application

It's time to enjoy your hard work, so run the application and enjoy your success.

Source code

You can get the source code of the above sample from top of this article.