Where is the SQLite db file located / saved on the Windows telephone device?

Question

I am working on a WP8 application using SQLite. Therefore, when the code to create and populate the database is executed, I want to be sure that the db file is actually created on the device, and also checks its contents using the SQLite browser.

When creating the database, I indicated the location of ApplicationData.Current.LocalFolder , but I have no idea where exactly on the device that points to.

Where can I find the SQLite db file on the device?

Answer 1

Go to Program Files (x86) \ Microsoft SDK \ Windows Phone \ v8.0 \ Tools \ IsolatedStorageExplorerTool. Go to this folder and run one of the following commands:

 ISETool.exe ts xd 8a40681d-98fc-4069-bc13-91837a6343ca c:\data\myfiles command, if you are running the application on emulator. ISETool.exe ts de 8a40681d-98fc-4069-bc13-91837a6343ca c:\data\myfiles command, if you are running the application on device. 

The third argument is the application product identifier, you can get it in the WMAppManifest.xml file, App tag, ProductId attribute. The product identifier of this example is 8a40681d-98fc-4069-bc13-91837a6343ca.

Now, if everything is in order, you should have a copy of the contents of the isolated storage in c: \ data \ myfiles; And the database file should be there too. Then you can add your database file to your project using the "Add an existing product" option.

Remember to change the Copy to Ouput Directory property of the added .sqlite file to copy if it is newer.

Answer 2

This did not help me in 8.1. I continued to receive the error message "This operation was returned due to a timeout error." I used Windows Phone Power Tools: http://wptools.codeplex.com/ , which is much easier to use.