Where is my SQLite database created?

c#, entity-framework, sql, sqlite, uwp

Solution

When you create an SQLite database without a specific path, it will be placed in the folder that your code can locate as `Windows.Storage.ApplicationData.Current.LocalFolder`

For your DB Browser, it is in

c:\Users\<username>\AppData\Local\Packages\<package-name>\LocalState\

`<username>` is obvious, `<pacakage-name>` can be found in your Package.appxmanifest, packaging tab. It looks like a Guid.

Problem

I am following the tutorial presented here: EF7 tutorial It seems to be a well-known tutorial about SQLite, UWP and EF7 all goes as expected when following it, but I was not able to find the physical path to the database created by the code-first approach. This thing is quite strange I wanted to open the sqlite database using "DB Browser for SQL Lite" but I could not find it anywhere... Did some of you follow this common tutorial and find the database or do you know where EF7 code first creates the database?

Original source