If you are more of a “behind-the-scenes” kind of developer though, you may prefer to make your SQL tables using good old SSMS and some scripts. In short 5+ minute video below, I walk you through the steps and gotchas around creating tables directly in SQL Azure, but consuming them via Windows Azure Mobile Services.
As for the gotchas, there are two that come to mind:
Your tables must have a primary key column called “id”.
Your table names should be “singular” (think “Category” not “Categories”) to allow for more appropriate class names on the client side. You wouldn’t want to create a class called “Categories” when it really represents a single category.
If you want a copy of the SQL script I use in the video blow, you can get it here: http://aka.ms/wcts
I love the Dev Camps we have been running lately because it gives me a great opportunity to show off all the great things we are doing around Windows 8 and Windows Azure. Case in point, at the Windows 8 Dev Camp in LA today (09/14/2012) I will be presenting on “Windows Azure Mobile Services”.
“Windows Azure Mobile Services” makes it super simple to create a cloud back-end for your Windows 8 WinRT apps. It provides you a way to manage data, authentication, and push notifications. Along with that you can scale your services as your app grows in popularity! Very cool.