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
You can take your existing HTML5/CSS3/JS skills to create first class apps in Windows 8. Not BROWSER based apps. Windows 8 apps. You can package them up, and sell them in the Windows Store, and make real money with them. Cool!
I’ve had the privilege over the past month to present what I have learned about Windows 8 HTML5/JS apps to the San Diego HTML5, and the San Diego JS meetups. If you happened to miss either of those, or just want to see why I am excited about it in general you can: