locked
How to use local .sdf database in a windows store apps

    Question

  • Hi,

    I am new in windows store app development. I have been working in WPF application development for long time. Now I want develop windows store apps. I am studying on it. I got a problem. I what to store data from windows store app in .sdf database file. I confused is .sdf database is compatible with windows store apps.

    I want Deploy the apps in windows apps store. Is .sdf database support in client machine while he download it and run his own machine.

    Please Suggest me about it with sample reference. It will be very helpful for me.

    bye

    With Regards

    Sadequzzaman Monoj

    Bangladesh

    Thursday, March 12, 2015 3:56 AM

Answers

  • SDF files are used by Microsoft SQL Server Compact Edition. SQL CE is not supported for Windows Store Apps/Universal Apps. Only WP Silverlight Apps can use SQL CE. You will have to switch to a different database format.

    As far as I know the only DB currently supported for local deployment with Windows Store Apps is SQLite.

    This article gives an introduction on how to get started with SQLite in Universal Apps: http://blog.tpcware.com/2014/04/universal-app-with-sqlite-part-1/

    Thursday, March 12, 2015 1:04 PM