Norway


Developer Guide Book 2nd Edition available now! This free eBook is available now at aka.ms/azuredevebook.

Intro

Most folks aren’t aware of how powerful the Azure platform really is. As I’ve been presenting topics on Azure, I’ve had many people say, “How did you do that?” So I’ll be documenting my tips and tricks for Azure in these posts.

The Complete List of Azure Tips and Tricks

Available Now!

your first Azure Table

In case you are new to the Azure Storage, we’ve reviewed the following options so far:

While we’ve been working with Azure Storage Blobs and Files, we’ll switch this week to taking a look at Azure Storage Tables.

What is Azure Storage Tables? They are a NoSQL key-value store for rapid development using massive semi-structured datasets*

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

So to recap, think of Azure Storage Tables as key-value data set that you can query vs. Azure Storage Blobs which are typically files.

Getting Started

Go ahead and open the Azure Portal and click Create a Resource and select Azure Storage. We’ll keep it simple as shown below to get started.

- storageacct1 - Azure Tips and Tricks Part 82 – Creating your first Azure Storage Table

Once complete, go into the resource and look under Services.

- storageacct2 - Azure Tips and Tricks Part 82 – Creating your first Azure Storage Table

Go ahead and click on Tables and you could create a new table through the portal as shown below.

- aztablesblog1 - Azure Tips and Tricks Part 82 – Creating your first Azure Storage Table

If we did that, then we’d see a table alongwith the URL that it is accessible from.

- aztablesblog2 - Azure Tips and Tricks Part 82 – Creating your first Azure Storage Table

While this is good and fine, we’d like to create the table dynamically to represent a -world scenario.

For this example, we’ll use C#.

While inside the blade for Azure Storage, look under Settings, then Access Keys and copy the connection string.

- storagethroughcsharp1 - Azure Tips and Tricks Part 82 – Creating your first Azure Storage Table

Create a C# Console Application using Visual Studio, and use NuGet to pull in references to :

  • WindowsAzure.Storage
  • Microsoft.WindowsAzure.ConfigurationManager

- storagethroughcsharp2 - Azure Tips and Tricks Part 82 – Creating your first Azure Storage Table- storagethroughcsharp3 - Azure Tips and Tricks Part 82 – Creating your first Azure Storage Table

Inside of your Console , you will see App.config, now add the following section:

  <appSettings>
    <add key="StorageConnection" value="YOUR-CONNECTION-STRING-COPIED-FROM-EARLIER"/>
  </appSettings>

Copy the following code into your Main method:

static void Main(string[] args)
{
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
                CloudConfigurationManager.GetSetting("StorageConnection"));
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("thankfulfor");
table.CreateIfNotExists();
Console.ReadKey();
}

This code will get our connection string from the App.config, create our client and a table named thankfulfor if it doesn’t exist. We can go back inside of the portal to see if executed correctly.

- aztablesblog3 - Azure Tips and Tricks Part 82 &#8211; Creating your first Azure Storage Table

Looking good so far! Now that we’ve created a table, let’s begin adding some data to it. Come back tomorrow or look at the master list if you aren’t following day by day.

Want more Azure Tips and Tricks?

If you’d like to learn more Azure Tips and Tricks, then follow me on twitter or stay tuned to this blog! I’d also love to hear your tips and tricks for working in Azure, just leave a comment below.





Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here