Take the 2-minute tour ×

How do I develop a WCF application in Windows Azure, using SQL Azure data?

Output should be in JSON format and input methods would have more then one parameter.

Requests would come from mobile devices, looking like "http://myservice.cloudapp.net/WCF_Serv?id=1&Table=emp"

All Devlopment would be C#.

share|improve this question
This is way to unclear and way too broad..... what is your issue? Developing the WCF part? The SQL part? What?? –  marc_s Jan 30 '12 at 7:15
add comment

2 Answers

up vote 1 down vote accepted

The question you asked is very broad, but assuming you're just looking for how to get started with WCF and SQL Azure:

Take a look at this Windows Azure Quick Start sample for setting up a WCF service in Windows Azure. You can then modify this sample to call out to SQL Azure to retrieve data. If you've worked with SQL Server, you should have no problem working with SQL Azure.

You can also look at this Quick Start sample for using SQL Azure with a website. You can borrow the salient code and use it with your WCF service.

EDIT: One thing I just noticed, while editing your question to be more readable: Your example looks like it's trying to directly access a table:


You are actually naming a table in the call (in this case, emp). In my opinion, this is not a good practice. Instead, you should be shaping your WCF services to return something meaningful without exposing your database schema.

share|improve this answer
add comment

Create new Windows Azure project, and then add WCF project as Web role or Worker role. Provide your SQL Azure database connection string in WCF config file for connecting with SQL Azure. Rest are same.

share|improve this answer
can send me gine any sample or example of code for that one? –  jainvikram444 Jan 30 '12 at 7:43
Have you installed windows azure with VS2010? –  Sandy Jan 30 '12 at 11:28
add comment

Your Answer


