Tips, tricks and all the info about Microsoft Visual Studio 2008

Windows Azure Table Storage - Getting Started - Part 1

, posted: 3-Mar-2009 09:00

Windows Azure provides simple data storage services like blobs, tables and queues to store your data in the cloud. These can be accessed using a Windows Azure Storage Account.


 
In this Part 1, we are going to look into the Windows Azure Table Storage which provides a structured storage in the cloud.

Pre-requisites
1) To get started with Windows Azure programming, you can have a read at my previous blog post
2) You need to have a Windows Azure Storage Account to program Windows Azure Storage. You can apply for one here

Check your Table Service in the Development Storage
Using the Development Storage tool,  Azure SDK simulates the Azure Tables in your local machine than in the cloud. The Table Service may fail to start and you won't be able to choose a proper Table Service Database. None of the SDK samples which uses the local Table Service would also not work.

The problem is that running the Development Storage tool initially created the Database (DevelopmentStorageDB)  (Azure SDK searches for a .\SQLEXPRESS instance by default) , but not the required Schemas. To install the required schemas, Traverse to where you had extracted the SDK Samples and execute the rundevstore.cmd script
 


Running the above script will create the necessary schemas for the SDK samaples and also will start the Table Service in your Development Storage
 


Windows Azure Table Storage




• Each account has a Table
• The Table has an Entity
• An Entity contains Columns
• Entity can be considered to be the row and Columns as values
• An Entity always contains these properties:
   o Partition Key
   o Row Key
   o Timestamp
• The Partition Key and Row Key identify a row or an Entity

As you may have guessed it already, partition key and row key is the first column of your table. All entities in a table with the same partition key value live in the same partition.

However, you can use either partition key or row key or both or do not use both.

Here is a simple guide on how to use partition key and row key

PK=empty, RK=empty - One partition, One row
PK=data, RK=empty - Multiple partitions, One row per partition
PK=empty, RK=data - One partition, Multiple rows for the one partition
PK=data, RK=data - Multiple partitions, Multiple rows for each partition

In our next blog post, we shall get into developing the sample guestbook application.

Visual Studio 2008 simplifies building Windows Azure applications using the Windows Azure tools for Visual Studio. It also allows us to debug Windows Azure applications.

Download Visual Studio 2008 90 day trial
For detailed information and to request a free 90-day trial DVD of Visual Studio 2008 Team Suite to be sent out to you, go to the Microsoft Visual Studio webpage.

About the Author
Chaks is currently working for Intergen as a Software Developer. Chaks works extensively in Microsoft Platform. His knowledge covers various Microsoft Technologies like WCF, SharePoint, Windows Azure, ASP.NET. Chaks also writes for Neowin, one of the Microsoft featured communities. You can contact Chaks via his blog - Chaks' Corner.

Other related posts:
The New Zealand ALM Conference 2011 (Application Life Cycle Management)
Writing your own Html Helpers for the ASP.NET MVC Framework
Automating Visual Studio 2008






About the Visual Studio 2008 Blog

In the years since the hugely successful release of Visual Studio 2005, Microsoft has used developer feedback from all over the world to introduce over 250 new features in the 2008 release.

This sponsored blog will bring Visual Studio 2008 tips and tricks from well known developers in the Australian and New Zealand tech community directly to you.

Make sure you bookmark this blog or subscribe to our RSS feed.



Other blog posts

The New Zealand ALM Conference...
Writing your own Html Helpers ...
Automating Visual Studio 2008...
Windows Azure Table Storage - ...
XML and XSLT in Visual Studio ...
Introduction to New SQL Server...
Using the Visual Studio 2008 P...
Getting started with Windows A...
Why consider sitting for an MC...
Unit testing .Net Compact Fram...


Some recent comments

Praveen M on Visual Studio 2008 support for building SilverLigh: I installed SILVERLIGHT TOOLS for VS2008 at my work. I am able to do silverlight...

zefo on Unit testing with Visual Studio 2008: Just minor recommendation: better use *.png for the screenshots. Jpeg is more su...

gil ziny on Unit testing with Visual Studio 2008: When I associate the unit test with TFS testing policy, if fails during check-in...

lynette on Visual Studio 2008 JavaScript Debugging: i have enable in IE the ability to debug scripts. if i go to my section in my c...

Junkie on Why consider sitting for an MCTS or MCP Certificat: The way you presented the case for certification has been completely different f...

Brian Link on Unit testing with Visual Studio 2008: You seem to be incorrect in one of your opening remarks - it seems that web.conf...

Dipanwaya on Unit testing .Net Compact Framework applications w: Steps Behind the Test in the VS 2008? How to test a module in the VS 2008 Envir...

Ricardo on Visual Studio 2008 support for building SilverLigh: Yes! Found the solution myself :) Reset the environment of Visual Web Developer...

Ricardo on Visual Studio 2008 support for building SilverLigh: Have the same problem after installing Visual Web Developer 2008 SP1 and Silverl...

kjward on Automating Visual Studio 2008: thanks lots for all the great info. i'm sure the answer to my question is in th...



Disclaimer

The Visual Studio 2008 blog is sponsored by Microsoft NZ. The blog posts are the authors' genuine accounts of their experiences with Visual Studio 2008 and are not influenced or filtered by Microsoft NZ in any way.