question

amol1608 avatar image
amol1608 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
stored-proceduresazureandroid
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You mean write the code in the application or on the server, in the custom API?
0 Likes 0 ·
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.
0 Likes 0 ·
Ok, I will try that, if I succeed I will mark the answer as correct. Thank you!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.