asked
Calling a Microsoft Azure stored procedure from Android
I have a table called user and I have a procedure on my Microsoft Azure mobile service called selectUser. It looks like this: create procedure [dbo].[selectUser] as select * from [dbo].[user]; go I need to call it from my android app and see its results. I already did query the database with MobileServiceClient and MobileServiceTable, using `UserTable.where().field(...).eq(...)` but I need to use stored procedures. Is there any way to do this? Thank you a lot
From what I can glean, the MobileServiceClient doesn't have a mechanism for calling procedures. Instead you'll have to write code directly against the msssql object. That will allow you to call a procedure with no issues.
Wherever you're making the call from. The preferred place for an Azure call would be on a web service, but you can do it from the client too.
15 People are following this question.
