TIP

💡 Learn more : Azure storage account overview.

Deleting an item from a Azure Storage Table

In case you are new to the Azure Storage Tables, we've reviewed the following items this week:

Today, we'll be taking a look at deleting an item through C# code into an Azure Storage Table.

Getting Started

Open the C# Console application that we were working with last week and let's add a method to:

  • Delete an item based off of the table, RowKey and PartitionKey that we pass in.

Delete an item

In our Program.cs file, we'll now add in a helper method that passes in a table, RowKey and PartitionKey to identify the message we want to delete.

static void DeleteMessage(CloudTable table, string partitionKey, string rowKey)
{
    TableOperation retrieve = TableOperation.Retrieve<Thanks>(partitionKey, rowKey);

    TableResult result = table.Execute(retrieve);

    var deleteEntity = (Thanks)result.Result;

    TableOperation delete = TableOperation.Delete(deleteEntity);

    table.Execute(delete);
}
1
2
3
4
5
6
7
8
9
10
11
12

In this example, we retrieve the message and then delete the entity.

Putting it all together.

The Main method inside of the Program.cs file, we'll call our helper method.

static void Main(string[] args)
{
    CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
                    CloudConfigurationManager.GetSetting("StorageConnection"));

    CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

    CloudTable table = tableClient.GetTableReference("thankfulfor");

    table.CreateIfNotExists();

    //added these lines
    DeleteMessage(table, "ThanksApp", "I'm thankful for the time with my family");
    //added these lines

    table.Execute(update);
    Console.ReadKey();

}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19