For Those Building New Apps in the Cloud

Azure Cloud on Ulitzer

Subscribe to Azure Cloud on Ulitzer: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Azure Cloud on Ulitzer: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Azure Authors: Yeshim Deniz, Elizabeth White, Pat Romanski, Zakia Bouachraoui, Nick Basinger

Related Topics: Ubuntu Linux Journal, SEO Journal, Azure Cloud on Ulitzer, Telecom Innovation

Blog Feed Post

Azure CLI Day 26 – mobile table create

bash-azure

In my previous two posts I showed you how to:

  1. View a list of preview features available to a Windows Azure Mobile Service( http://thinkfirstcodelater.com/blog/?p=3242)
  2. Enable a preview feature for a Windows Azure Mobile Service(http://thinkfirstcodelater.com/blog/?p=3242)

In this post I’m going to start showing you how to work with data by creating a table in a SQL database using the Windows Azure cross platform command line tools.

Once again, just a reminder that I’m using the command line tools on a MacBook Air with OSX (Mountain Lion) installed, and I’m using Google Chrome as my default browser. However, the experience should be identical on Windows and Linux as well.

Open an instance of your command line (Terminal, Bash, Command Prompt, etc.) and type the following:

azure mobile table create -h

Screen Shot 2013-09-21 at 3.26.48 PM

The azure mobile table create command will create a table in the SQL database associated with the Windows Azure Mobile Service. There are only two required parameters:

  1. [servicename] – the name of the service you want to create the table for
  2. [tablename] – the name of the table to create

An additional option (-p or –permissions) allows you to set granular level permissions for the table. We’ll look at this option in the next post.

Enter the following into your CLI to create a table named “ToDoItem”, substituting where applicable:

azure mobile table create “[YOUR MOBILE SERVICE NAME]” “ToDoItem”

In my case I entered the following:

azure mobile table create “zumo101″ “ToDoItem”

Screen Shot 2013-09-21 at 3.35.12 PM

To verify the table has been created, go to the Windows Azure management portal by opening your Internet browser and navigating to https://manage.windowsazure.com” and sign in. Once signed in, go to the Mobile Services portion of the Windows Azure management, click on your Mobile Service, then click on the Datalink. The ToDoItem should display in the list of tables.

Screen Shot 2013-09-21 at 3.36.50 PM

If you click on the ToDoItem table, then click the Permissions link you’ll see that all operations are restricted to only those users with the application key.

Screen Shot 2013-09-21 at 3.41.06 PM

In the next post I’ll show you how to create a table and specify different permissions for different operations.

Did you know you can try Windows Azure for free for 30 days? Just go to http://aka.ms/thecloud and sign up.

Read the original blog entry...

More Stories By Adam Grocholski

Hey there! My name is Adam Grocholski, and I'm a Technical Evangelist at Microsoft where I spend time focusing on Windows, Windows Phone, and Windows Azure. I live in the frozen tundra of Minnesota and run thinkfirstcodelater.com. You can also follow me on twitter at @codel8r.