General Question about json, azure and an App

Question

Hi

I am just new to developing Windows Store apps. I am looking at this from a high level, tell me if i'm right in what i say.

Lets say i am setting up a news story web app. I provide the content. I have an SQl database set up in azure. A simple 1 table database, with news items in it. I want the new items fed to a windows 8 app and windows 8 phone app.

From azure, it connects to some kind of service is this called Windows Communication foundation?, or a rest service or something. It coverts the data to a json file and sends it down the wire (so to speak). The app receives it as a json file and stores it locally in some folder. It then pulls that file into a Sqlite database in the app. From the sql lite database, i feed the data to the main app pages.

Is what i am saying here correct?

How do i go about creating the json file at the azure level? Is this easy achieved? Is this the best method. My understanding is json is the best format to use because it is "light"?

How do i go about setting up this service that hands out the data from the server?

Any help would be most appreciated. (at a high level)

Answer 1

one other question, can a windows store app be put on xbox one store? Or are there any hoops i have to jump through to get an app there? Do microsoft plan on allowing this to happen? If so when, and how do i go about preparing to release an app in this format? (what tools do i need - do i need any special sdks? or extensions or the likes?)

Answer 2

one final question, if i have images stored in the sql table, can images be sent down the live via json?

Answer 3

Hi ConorS79,

Basically, what you said is correct, for example, we can create mobile service based on ASP.NET Web API, it gives us a first way to create REST APIs, here is a simple sample: https://code.msdn.microsoft.com/Leaderboard-App-with-Azure-9acf63af

It seems like you need more help about Azure Mobile Services, so The Azure Mobile Services forum should be a better place for additional questions: http://social.msdn.microsoft.com/Forums/en-US/home?forum=azuremobile

By the way, please don't ask multiple questions in one thread, you could open new thread for other new question.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 4

Thanks for that Franklin. Much appreciated.