CODEWITHSUNDEEP
sqldatabaseapiazure
Libor Zapletal
Libor Zapletal

Reputation: 14092

Windows Azure - sql database with api

I have SOAP services with data. I want to download all data from that service and upload it to my own server and then use these data from my server (don't worry I have permission for that). I want to do it because now I don't have function from that service which I need.

I want to use Windows Azure for this and I think SQL Database scenario would be best. Now I have classes for previous SOAP service so I think EF Code first would help me with creating database and I upload data somehow. But what about API? How can I access my data from windows phone or tablet? Is azure database enought or I must create more? Is there any good article for that?

Upvotes: 1

Views: 3819

Answers (2)

Sandrino Di Mattia
Sandrino Di Mattia

Reputation: 24895

Windows Azure gives you a few options to expose an API to your mobile clients:

Upvotes: 1

Robert Greiner
Robert Greiner

Reputation: 29722

I think what you are saying, is that you are aggregating data from several sources and storing the information in your own database. And, you would like your database to be Azure Database. Then, you want to build an API to expose the data you retrieved.

If this is indeed your goal, then yes, Azure will do everything you need. I'd recommend checking out Web API in conjunction with your Azure deployment. I've used this scheme with some success over the past year.

Warning: You should know that Azure Database does not have an SLA which means that Microsoft does not guarantee any level of performance including transactions/second. This means that if your API has a high load, you could end up getting throttled heavily in an unpredictable way. I've been bitten by this before and ended up moving my data to Azure Table Storage instead.

Upvotes: 2

Related Questions