Insert Data Into Azure Table Storage Using ASP.NET Core Application

Step 4. In the above image, the Storage Account Name means Account Name. Also, Select Storage V2 options to avail the service of all four data services of Azure Storage Accounts.

Step 5. Now click on the review and create option.

Step 6. After the settings are validated, click Create to create the account.

Step 7. Once the deployment is succeeded, click Go to resource options to open the Storage Account.

Step 8. Once the Storage Account is created, click on the Access Keys options of the left panel and copy the ConnectionString value. This value needs to be provided in our web application so that we can upload files in Azure blob storage.

Create console application using Asp.Net core in VS 2019

Step 1. Now open Microsoft Visual Studio 2017 and click on File -> New -> Projects.

Step 2. Select the Console App Project template and Click on the OK Button.

Step 3. Now, we need to install the below Nuget Packages to access Azure storage account using the Microsoft Azure Storage Cosmos Table client driver.

Step 4. Now, first, we need to establish communication between our application and the Azure Storage account. For that purpose, we will create a CloudStorageAccount instance and parse the connection string to the class instance. After it, we need to create the instance of CloudTableClient so that we can establish a connection with Azure Storage accounts. Now after this, we need to create an instance of CloudTable which will provide us a reference of Table Objects in the Azure Table storage.

static string storageconn = "DefaultEndpointsProtocol=https;AccountName=demofilestoragesamples20;AccountKey=fw/Z6ou//OXhfIvwe8fZsHna3yJrW92iGOSJH/3hGkekhtxmg==;EndpointSuffix=core.windows.net";  
static string table1 = "Employee";  
static string partitionkey = "Debasis Saha";  
static string rowKey = "userC";  
static void Main(string[] args)  
{  
    CloudStorageAccount storageAcc = CloudStorageAccount.Parse(storageconn);  
    CloudTableClient tblclient = storageAcc.CreateCloudTableClient(new TableClientConfiguration());  
    CloudTable table = tblclient.GetTableReference(table1);  
    Console.ReadKey();  
}  

Step 5. Now, first, we will try to insert a single record into the Azure Table Storage named Employee. For that purpose, we will create the below method.

public static async Task<string> InsertTableEntity(CloudTable p_tbl)
{
    Employee entity = new Employee("Debasis Saha", "userC");
    entity.Salary = 50000;
    TableOperation insertOperation = TableOperation.InsertOrMerge(entity);
    TableResult result = await p_tbl.ExecuteAsync(insertOperation);
    Console.WriteLine("Employee Added");
    return "Employee added";
}

Step 6. Now run the application and then check the Storage Explorer in the Azure Portal.

Step 7. Now, if we want to insert bulk data then we can use the below method.

public static async Task<string> InsertBatch(CloudTable p_tbl)
{
    TableBatchOperation l_batch = new TableBatchOperation();
    // All of the records should have the same partition key
    Employee entity1 = new Employee("Swapan Sharma", "user1");
    entity1.Salary = 35000;
    Employee entity2 = new Employee("Swapan Sharma", "userB");
    entity2.Salary = 20000;
    Employee entity3 = new Employee("Swapan Sharma", "userC");
    entity3.Salary = 30000;
    l_batch.Insert(entity1);
    l_batch.Insert(entity2);
    l_batch.Insert(entity3);
    p_tbl.ExecuteBatch(l_batch);
    Console.WriteLine("Records Inserted");
    return "Completed";
}

Step 8. Now after executing the program, check the Storage Explorer to view the data.

Step 9. Now, if we want to query the table against any particular partition key, then the below method needs to be executed.

public static async Task<string> Query(CloudTable p_tbl)  
{  
    TableQuery<Employee> CustomerQuery = new TableQuery<Employee>().Where(  
        TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Swapan Sharma"  
        ));  
    var itemlist = p_tbl.ExecuteQuery(CustomerQuery);  
    foreach (Employee obj in itemlist)  
    {  
        Console.WriteLine("The Employee Name is " + obj.PartitionKey);  
        Console.WriteLine("The User Name is " + obj.RowKey);  
        Console.WriteLine("The Salary is " + obj.Salary);  
    }  
    return "Operation complete";  
}  

Step 10. Now run the program to check the output.

Conclusion

In this article, we discussed how to store data using the Asp.Net Core application in Azure Table Storage. Any suggestions feedback or queries related to this article are most welcome.