With Windows Azure 1.3 release I am super excited to see the most desired features addition and new portal. I will be posting on new feature soon. What remains the same as backbone of Windows Azure is the storage mechanism - a robust, secured and accessible location to capture user data apart from regular SQL Azure. Here I have tried to make it simplified for all of us who is starting new.
What we want to achieve?
We want to create a table called REEntry having few columns Alias, TopicTitle, Agenda etc., and from ASP.NET application we will store and view them.
Then after that in the Solution Explorer choose the project WebRole1 and right click to choose setting.
Add a new setting called “DataConnection” of type Connection String as Windows Azure Storage Emulator. This will use the local SQL Express table to store during development.
After that add a Class Library project to your solution called ReadinessEventDBLibrary. Here we will be creating all our Entity, Context and Public methods.
We need to refer to assemblies here Microsoft.WindowsAzure.StorageClient and System.Data.Services.Client.
After that we need to use the below using block,
We will have to define the Table structure
Here we will be defining the Context.
This will not only initialize the previous class but have those public methods by which we can add or access data from Azure Storage
Hit F5 to run the application but ensure that you are running Visual Studio 2010 in elevated mode.
Data can be visible from Server Explorer of Visual Studio 2010.
A very special thanks goes to Azure Training Kit. Download it today and learn Azure, nothing better than this. Enjoy Windows Azure and keep programming for Cloud!!!
One very important thing you forgot to mention in your tutorial is that you have to set the Cloud storage account -something like
(configName, configSettingPublisher) =>
var connectionString =
You can do this on WebRole Startup , but as of Windows Azure SDK 1.3 you are advised to do this in Global.asax Application Startup .
See reference here blogs.msdn.com/.../how-to-resolve-setconfigurationsettingpublisher-needs-to-be-called-before-fromconfigurationsetting-can-be-used-after-moving-to-windows-azure-sdk-1-3.aspx
How to retrieve values from azure table-storage.
To get the data from Storage you can use LINQ as below.
var results = from c in context.ReEntry
where c.PartitionKey == DateTime.UtcNow.ToString("MMddyyyy")