I’m working on a mobile app for the moment and decided it was a good opportunity to look into the Windows Azure Mobile Services.
During my investigation I have found the following articles particular usefull.
Client side query syntax: http://www.c-sharpcorner.com/UploadFile/0926bc/crud-operation-in-htmljavascript-using-windows-azure-mobile/
If you need to query for all items in an array a typical T-SQL contains, then you can use the following syntax table.where(function, parameters).read(options);:
// find all TodoItem records with id = 2 or 3
var todos = tables.getTable("TodoItem");
todos.where(function(arr) {
return this.id in arr;
}, [2, 3]).read({
success: console.log(results);
});
Server side: http://blogs.msdn.com/b/carlosfigueira/archive/2012/09/21/playing-with-the-query-object-in-read-operations-on-azure-mobile-services.aspx
http://www.thejoyofcode.com/The_twelve_days_of_ZUMO.aspx
Sendgrid: http://www.windowsazure.com/en-us/develop/mobile/tutorials/send-email-with-sendgrid/