How to find .NET Maui sqlite DB file

Question

I have a .NET Maui Blazor App and configured SQLite storage via Entity Framework Core:

builder.UseSqlite($"Data Source=app.db")

Everything is working fine. For debugging purposes, I want to access the SQLite database file from a database explorer. I found that the file is stored at this location, when I start the app in Debug mode for Windows target.

c:\Users\<username>\AppData\Local\Packages\5A71F6B4-07D1-4042-BC1C-C1FD1963A030_9zz4h110yvjzm\LocalState\app.db.

This is poor developer experience. How can I "mount" the database file from outside a .NET Maui Blazor app or specify the file path on the debugging host machine so that it's not random?

How can I specify a file location that is not generated randomly? I had to search my whole file system to find this file. — Andreas Gyr
– Andreas Gyr, Commented Feb 5, 2023 at 20:48
Is this the doc you used to know about builder.UseSqlite: Net Maui local databases? In your app, find what value is returned for FileSystem.AppDataDirectory. Is that the directory that was used? — ToolmakerSteve
– ToolmakerSteve, Commented Feb 5, 2023 at 22:58
@ToolmakerSteve I saw it. However, FileSystem.AppDataDirectory is not available for me. — Andreas Gyr
– Andreas Gyr, Commented Feb 6, 2023 at 8:03

Alexandar May · Accepted Answer · 2023-02-06 06:55:27Z

5

The generated randomly file folder is {GUID}_{hash} which is generated randomly. If you want to specify the path that the db located and remove the randomly number, you can try to use below which is located in c:\Users\<username>\AppData\Local\:

string dataSource = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "app.db");

builder.UseSqlite($"Data Source={dataSource}");

Or you can use absolute path located in C:as Dimi suggested,

builder.UseSqlite(@"Data Source=C:\app.db");

answered Feb 6, 2023 at 6:55

Alexandar May

10.5k1 gold badge14 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Andreas Gyr Over a year ago

Thanks. Storing in c:\Users\<username>\AppData\Local\app.db does NOT work. That's what I already tried. However, storing in C:\app.db works.

Andreas Gyr Over a year ago

Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "app.db"); is NOT working. So I accepted Dimitri's answer.

Dimitris Maragkos Over a year ago

What do you mean "does not work"? Do you get an error? Which path do you get from Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "app.db");

Dimitris Maragkos · Accepted Answer · 2023-02-05 22:59:53Z

2

You can specify the database location by providing an absolute path in the connection string:

options.UseSqlite("Data Source=C:\your\path\app.db");

answered Feb 5, 2023 at 22:59

Dimitris Maragkos

11.6k2 gold badges17 silver badges37 bronze badges

Collectives™ on Stack Overflow

How to find .NET Maui sqlite DB file

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related