Executing stored procedures on SQL Azure database using REST API or Azure Management Libraries

Question

Is there a way to create an execute stored procedures on SQL Azure database using REST API or Azure Management Libraries?

I checked Operations for Azure SQL Databases here http://msdn.microsoft.com/en-us/library/azure/dn505719.aspx and Management Libraries for .NET here http://msdn.microsoft.com/en-us/library/azure/dn602775(v=azure.11).aspx, and I don't see any options.

You might want to consider utilising OData instead and remove the need for sprocs. — Simon W
Maybe you could give me some links so that I could understand your idea better. Thanks. — myroslava72
As of what I read I see that it is possible to use OData to query the DB, retrieve information, add data. But what about system stored procedures like sp_adduser or something? — myroslava72
OData is an open standard - details at odata.org. You need to expose your Database using a logic tier that can be written in whatever language you like. You can expose Stored Procedures in your logic tier easily enough. — Simon W

Gaurav Mantri Gaurav Mantri · Accepted Answer · 2015-01-05T13:42:12

No, this is something you would need to do in your application. The REST API provides management capabilities at the infrastructure/platform level. Procedure execution would fall under application level IMHO. Management Library for .Net is simply a wrapper around these REST API.

I think your only option would be write your own API specific for your application/database that can execute the stored procedure in your database.

Executing stored procedures on SQL Azure database using REST API or Azure Management Libraries

2 Answers