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!

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

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

• Edited by Joseph IdziorekMicrosoft employee 6 hours 46 minutes ago

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

• Edited by Joseph IdziorekMicrosoft employee 6 hours 35 minutes ago

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

• Edited by Joseph IdziorekMicrosoft employee Tuesday, February 17, 2015 4:53 AM
• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Wednesday, February 25, 2015 6:38 AM

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

• Edited by Joseph IdziorekMicrosoft employee Tuesday, February 17, 2015 4:53 AM

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

• Edited by Joseph IdziorekMicrosoft employee Tuesday, February 17, 2015 4:53 AM
• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator 4 hours 52 minutes ago

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

• Edited by Joseph IdziorekMicrosoft employee Tuesday, February 17, 2015 4:53 AM
• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Wednesday, February 25, 2015 6:38 AM