Custom Mobile Service API

Question

Hi. 

I have a series of records contain within an SQL table accessed through a mobile service. I was wondering how I could pass a parameter from the client to a custom API mobile service for use in an SQL query?

For example, my table contains temperature and date data. I am looking to be able to select a date on a client and use it in a query.

For example, "SELECT TEMPERATURE FROM TABLE WHERE DATE = " + DateFromClient + ""

My client is a Windows 8 c# App.

Cheers!

Answer 1

Hi RayD_250592,

Since the issue is more related to Azure Mobile Services, for quick and accurate answer, I recommend you post the question in the Azure Mobile Services forum at https://social.msdn.microsoft.com/Forums/en-US/home?forum=azuremobile .

Besides, you can also check the following articles about Azure Mobile Services.

Custom Parameters in Azure Mobile Services
http://blog.amitapple.com/post/30921523746/customparametersinmobileservices/#.VOKzGP4fqM8

Custom API in Azure Mobile Services – Client SDKs
http://blogs.msdn.com/b/carlosfigueira/archive/2013/06/19/custom-api-in-azure-mobile-services-client-sdks.aspx

Thanks,
Lydia Zhang

---

Lydia Zhang
TechNet Community Support

Answer 2

Hi Ray,

You're going to want to use a SQL parameter.  The following should help:

• http://www.dotnetperls.com/sqlparameter
• http://www.csharp-station.com/Tutorial/AdoDotNet/Lesson06