Stored Procs and Azure Mobile Service

I have found many examples of using mssql.query in Azure server-side scripts to run stored procedures.

My question is...

Can I call an SP from my client application through Azure Mobile Service ?
LVL 1
DodsworthAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DodsworthConnect With a Mentor Author Commented:
Looks like this is the way to go..

http://www.windowsazure.com/en-us/develop/mobile/tutorials/call-custom-api-dotnet/

Long winded or what ?

an App.MobileService.RunSQLAsync method would be nice :)

Any further thoughts ?
0
 
DcpKingCommented:
Yes you can. Brian Hitney of Microsoft explains it here.

 var sql = "exec schema.StoredProcName";
       mssql.query(sql, params,
       {
            success: function(results)   //etc
      }

hth

Mike
0
 
DodsworthAuthor Commented:
I read this before.  Isn't that example server-side ?
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
DcpKingCommented:
It seemed to be client-side, from what he says, but I'll admit, he's not totally explicit.

The point he's really making, I think, is that if you can run a straight T-SQL query, like "select field1, field2 from table1 where field3 is not null", then you can rum a stored procedure in the same way - "exec storedprocedurename", and shows how to give it a parameter (using a placeholder, the "?").

Can you execute straight T-SQL?

Mike
0
 
DodsworthAuthor Commented:
I dunno.  Hence the question :)
0
 
DodsworthAuthor Commented:
No further comments
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.