Creating Custom Tables for Windows Azure Mobile Services…

If you have used Windows Azure Mobile Services (WAMS) in the past , you have probably created tables using the management portal. If you haven’t used WAMS, WHAT ARE YOU WAITING FOR!???

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:

  1. Your tables must have a primary key column called “id”.
  2. 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:

Building Windows 8 Apps using HTML5, CSS3 and JavaScript

When it comes to Windows 8 apps, I have to admit, I’ve been more of a C#/XAML kind of guy.  However, lately, I’ve been looking into a number of the HTML5 based game tools (like Scirra’s Construct 2) and figured that I ought to learn a little more about building Windows 8 apps using HTML5 and JavaScript. 

I’ve been building web apps on various platforms going back to the first web server for windows written by Bob Denny (Any other VB CGI devs out there?), so HTML is second nature to me.  JavaScript?  Well, not so much, but I’ve done my fair share.  What I found out when I started digging into HTML5/JS dev for Windows 8 though was that I liked it a lot more than I expected to.  If fact, it’s pretty darn cool. 

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:

Get the free “Programming Windows 8 Apps with HTML, CSS, and JavaScript” eBook by Kraig Brockschmidt

Grab a copy of my slides and demos

Watch a YouTube video of my presentation