Retrieving Records - Understanding Table Storage

In this article, we will see how to retrieve records from an Azure Table Storage. Before working with this demo, I have already added two more records to our table in the same partition called Customer1 and Customer2,

Step 1

First, we are going to see how to retrieve a single record from the table. Open your project, remove or comment the method call and method for creating the customer that we did in the previous exercise and add the following method RetriveCustomer, with parameters, CloudTable, PartitionKey and the RowKey to uniquely identify the customer to your class.

public static void RetrieveCustomer(CloudTable table, string partitionKey, string rowKey)
{
TableOperation tableOperation = TableOperation.Retrieve<Customer>(partitionKey, rowKey);
TableResult tableResult = table.Execute(tableOperation);
Console.WriteLine(((Customer)tableResult.Result).CustomerName);
}

Add the method call code to your Main method after the code for getting table reference.

RetrieveCustomer(table, "registered", "[email protected]");
Console.ReadKey();

Azure

Step 2

To get the result, we have to create a constructor for the class Customer without parameters. Open Customer.cs class in the Entities folder and copy the following code to the class.

public Customer()
{
}

Azure

Step 3

Run your application and you can see the corresponding name is retrieved according to the Partition-key and Row-key we provided.

Step 4

Now we will see how to retrieve all the records in the table within a particular partition. Remove or comment the method call and method to retrieve single customer and add the following method to your class which will retrieve all the records. Here we need to pass just the table reference as a parameter and use a filter condition to get the records from the particular partition.

static void RetrieveAllCustomers(CloudTable table)
{
TableQuery<Customer> query = new TableQuery<Customer>()
.Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "registered"));
foreach (Customer customer in table.ExecuteQuery(query))
{
Console.WriteLine(customer.CustomerName + " " + customer.CustomerEmail);
}
}

Copy the following code to your Main method to call the method we just added.

RetrieveAllCustomers(table);

Azure

Step 5

Run your application and you can see that all the records in the particular partition have been listed.