Implementing Azure Storage Tables

Introduction

Azure Storage is a non-relational (NoSQL) entity storage service on Microsoft Azure. When you create a storage account, it includes the Table service alongside the Blob and Queue services. Table services can be accessed through a URL format. It looks like this,

http://<storage account name>.table.core.windows.net/<table name>.

There are many forms of NoSQL databases:

Key-value stores organize data with a unique key per record and often allow for jagged entries where each row might not have a complete set of values.

Document databases are similar to key-value stores with semi-structured, easy-to-query documents. Usually, information is stored in JavaScript Object Notation (JSON) format.

Columnar stores are used to organize large amounts of distributed information.

Graph databases do not use columns and rows; instead, they use a graph model for storage and queries, usually for large amounts of highly distributed data.

Table storage is a key-value store that uses a partition key to help with scaled out distribution of data and a row key for unique access to a particular entry. Together, these keys are used to uniquely identify a record in the account.

Using basic CRUD Operations

Step 1: Start Visual Studio 2015 and create a C# Console application,



Step 2: Go to Azure Management portal and create a new storage account.



Step 3: In Visual Studio 2015 under app.config file, add an entry under the Configuration element, replacing the account name and key with your own storage account details,