Databases and Windows store apps

Question

Hello, I am looking into storing data as part of my app and would like to create a database for this. Ideally the data would be available to the user no matter what system they use, i.e. if they have two computers, the data is shared or at least in sync. What is the best practice for this? can one use an sqlite database on the one drive? or should a database that is for all app users a better solution (it would get potentially very large if many used the app).

Thanks!

Answer 1

Hello. You need to have your own server to synchronize data or read about Azure Mobile Services.

Answer 2

A local database is not the way to go if you want to be able to access the same data from several different locations.

You could for example use the Windows Azure Mobile Services to store data in the cloud. Please refer to the following link for more information about this: http://azure.microsoft.com/en-us/documentation/articles/mobile-services-windows-store-dotnet-get-started-data/.

Please also refer to the following thread for more options of how to store data: http://stackoverflow.com/questions/13953940/windows-8-store-apps-which-type-of-storage-to-use

Yet another option is to define your own service layer somewhere (for example in the could), read and write from and to a SQL Server from this service and then comminicate with the service from your App.

Please remember to mark helpful posts as answer and/or helpful.

Answer 3

Thanks for your answer - I will look into azure!