LINK - Setup Azure Mobile Service for existing Azure Sql database

LINK - http://blogs.msdn.com/b/jpsanders/archive/2013/05/24/using-an-existing-azure-sql-table-with-windows-azure-mobile-services.aspx

There are a couple of requirements for using an Azure SQL table seamlessly with Mobile Services (at the time of this writing):

• • The table must be in the schema of your Mobile Service (the schema is the name of your Mobile Service)
  • The table must have an identity column called ‘id’ and it must be all lower case letters
  • The column types must be correct (for example not nvarchar(50) but nvarchar(max) )

LINK - http://chrisrisner.com/Connecting-an-Existing-Database-to-Windows-Azure-Mobile-Services