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