How To Insert The Data In Azure Storage Table

Loading

How To Insert The Data In Azure Storage Table

Introduction

This article will help you learn how to insert the items in the Azure Table Storage.

Before reading this article, please go through some important articles mentioned below:

Azure Storage

Azure Storage is one of the cloud computing PaaS (Platform as a Service) services the Microsoft Azure team provides. It provides cloud storage that is highly available, secure, durable, scalable, and redundant. It is massively scalable and elastic. It can store and process hundreds of terabytes of data, or you can store the small amounts of data required for a small business website.

What is Table storage?

Azure Table Storage stores large quantities of structured information. The service is a NoSQL datastore that allows authenticated calls from inside and outside the Azure cloud. Azure tables are ideal for storing structured and nonrelational data.

Common uses of Table storage include,

Storing TBs of structured data capable of serving web scale applications
Store data sets that do not require complex joins, foreign keys, or stored procedures and can be denormalized for quick access.
Quickly querying data using a clustered index.
Access data using OData protocol and LINQ queries via WCF Data Service .NET. Libraries

Prerequisites

Microsoft Azure Account.

This article demonstrates how to add data in Azure Tables.

Step 1

First, create a storage account.

How to insert the data in Azure Storage Table

Step 2

Navigate to the Data Storage menu, then choose” Tables”. Now, create the table.

How to insert the data in Azure Storage Table

Enter the table name and click on “OK”

How to insert the data in Azure Storage Table

Copy the connection string from the Access key

How to insert the data in Azure Storage Table

Now, create the console application in visual studio to create a table through the program.

How to insert the data in Azure Storage Table

Enter the project name, and next to create a console application

Install Azure.Data.Tables package

How to insert the data in Azure Storage Table

Click on the ok button

How to insert the data in Azure Storage Table

Add the following coding and also insert the connection string.

using System;
using System.Configuration;
using Azure.Data.Tables;
namespace azuretable {
    class Program {
        static void Main(string[] args) {
            var serviceClient = new TableServiceClient("Paste the connection string");
            TableClient table = serviceClient.GetTableClient("Azure");
            table.CreateIfNotExists();
            var tableEntity = new TableEntity("Product", Guid.NewGuid().ToString()) {
                {
                    "Product",
                    "Pen"
                }, {
                    "Price",
                    5.00
                }, {
                    "Quantity",
                    21
                }
            };
            table.AddEntity(tableEntity);
            Console.ReadKey();
        }
    }
}

How to insert the data in Azure Storage Table

Run the program

How to insert the data in Azure Storage Table

Summary

I hope you understood how to insert the items in the Azure storage table.