Tip 83 - Adding an item to a Azure Storage Table

TIP

💡 Learn more : Azure storage account overview (opens new window).

# Adding an item to 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 adding an item to the Azure Storage Table that we were working with yesterday.

As a refresher, Azure Storage Blobs can store any type of text or binary data, such as a document, media file, or application installer. Blob storage is also referred to as object storage.

# Getting Started

Open the C# Console application that we were working with previously (opens new window) and let's add a folder called Entities and add a class named Thanks.

Copy the following code into your new class:

using Azure;
using Azure.Data.Tables;
using System;

namespace TipsAndTrickSampleTest.Entities
{
    class Thanks : ITableEntity
    {
        public string Name { get; set; }
        public DateTime Date { get; set; }
        public string PartitionKey { get; set; }
        public string RowKey { get; set; }
        public DateTimeOffset? Timestamp { get; set; }
        public ETag ETag { get; set; }

        public Thanks(string name, DateTime date)
        {
            Name = name;
            Date = date;
            PartitionKey = "ThanksApp";
            RowKey = name;
        }

        public Thanks()
        {

        }
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

This entity use ITableEntity as base which will make it easier to work with Azure Storage Tables. We are going to create two fields in our table named Name and Date. We'll pass in the Name we want to use via a string and provide the current Date for the Date property.

Heading back over to our Program.cs file. We'll now add in a helper method to create the item in the table.

static void CreateMessage(TableClient table, Thanks message)
{
    table.AddEntity(message);
}

1
2
3
4

This will take advantage of our Thanks class and we'll pass in the message along with the date in the Main method.

The Main method inside of the Program.cs file just needs to call the method as shown below:

static void Main(string[] args)
{
    var serviceClient = new TableServiceClient(ConfigurationManager.AppSettings["StorageConnection"]);

    TableClient table = serviceClient.GetTableClient("thankfulfor");
    table.CreateIfNotExists();

    //added this line
    CreateMessage(table, new Thanks("I am thankful for the time with my family", DateTime.Now));
    //added this line
    Console.ReadKey();
}

1
2
3
4
5
6
7
8
9
10
11
12

If we run the program now, then it will add our message along with the current DateTime to our Azure Storage Table called thankfulfor. If we want to test it now, then we can use Azure Storage Explorer (opens new window). If you come back tomorrow, then I'll show you how to do this through code.

← Tip 82 - Creating your first Azure Storage Table
Tip 83 - Adding an item to a Azure Storage Table →