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

Question

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.

I don't have a `Packages` folder under `AppData\Local\`. What do *I* do? Windows 7. — DSlomer64, Sep 11 '17 at 22:33

score 1 · Accepted Answer · answered Oct 17 '14 at 20:35

1

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.

answered Oct 17 '14 at 20:35

Filip Skakun

31,624
6
74
100

But I mean for hooking it up to the SQLite Toolbox - do I have to go on a hunting expedition down every rabbit hole (Welchy folder) each time I add a SQLite database to a project? – B. Clay Shannon-B. Crow Raven Oct 17 '14 at 20:37
1

Sorry, I don't know SQLite Toolbox. Maybe some SQLite tools automatically find databases for you.... – Filip Skakun Oct 17 '14 at 21:51
It's made by the SQL CE Whisperer. I'm going to see if LINQPad connects to SQLite more automatically. The nice thing about SQLite Toolbox is it is incorporated right into VS. – B. Clay Shannon-B. Crow Raven Oct 17 '14 at 22:14
LINQPad is almost exactly the same in how one connects and what it shows. Has anyone ever seen SQLite Toolbox and LINQPad at the same time? If not, they may be the same "animal." – B. Clay Shannon-B. Crow Raven Oct 17 '14 at 22:21

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

1 Answers1