Attaching to a Windows Azure Mobile Services database in ASP.NET

The preferred way to talk to the database you are using for you Windows Azure Mobile Services is through the REST APIs and by using the Clients we supply for you.  The reason you should go through the REST APIs is to ensure you are hitting the Scripts you defined in your Mobile Service.  I…

0

Using an existing Azure SQL table with Windows Azure Mobile Services

You can use an existing Azure SQL table with your Mobile Services by moving the table to the schema used by your Mobile Service.  This blog post will show you one technique to accomplish this. In this sample the table we want to use with the Mobile Service is in the dbo schema.  The table…

10

Windows Azure Mobile Services – Accessing a Stored Procedure from a different Schema

I needed to access a stored procedure in the same database but for a different schema and call it from a server side script in Windows Azure Mobile Services, however I was getting this error: Error occurred executing query:  “Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]The EXECUTE permission was denied on the object ‘Test’, database…

1