CODEWITHSUNDEEP
sqlitewindows-runtimewindows-store-appsappdatauserappdatapath
B. Clay Shannon-B. Crow Raven
B. Clay Shannon-B. Crow Raven

Reputation: 10267

Is there a quick way to locate the SQLite database that my app creates?

I used this blog post as a basis for creating my SQLite tables.

Using the SQL Server Compact/SQLite Toolbox, I can view the created tables nicely.

However, in order to first create the connection in that tool, I had to locate the SQLite database I had created. I did a hard drive search for it, and found it in:

C:\Users\Clay\AppData\Local\Packages\99129e92-ebeb-4800-a0e5-
d0e43b016009_qtyjefqf75sa6\LocalState\photrax.sqlite

Now how in the world would I know that it was in 99129e92-ebeb-4800-a0e5- d0e43b016009_qtyjefqf75sa6 (there are many similar Welch-looking folder names beneath C:\Users\Clay\AppData\Local\Packages, so how would I know which one it's in)?

Surely there's a more elegant way to find it than doing a global search.

Upvotes: 0

Views: 584

Answers (1)

Filip Skakun
Filip Skakun

Reputation: 31724

C:\Users\Clay\AppData\Local\Package is where all your apps store their data and 99129e92-ebeb-4800-a0e5- d0e43b016009 is most likely your package ID from the appx manifest. You can just use ApplicationData.LocalFolder.Path to get the path.

Upvotes: 1

Related Questions