CODEWITHSUNDEEP
c#sqlitedatabase-connectionwin-universal-app
rur2641
rur2641

Reputation: 699

sqlite database location uwp

I have an uwp app with a sqlite database that works as intended; I can close the program and restart it and the database is loaded properly. I want to look at the database with a database viewer but can't locate the file. I have tried unhiding files and searching for db.sqlite. Here is the code that connects to the database:

string path;
SQLite.Net.SQLiteConnection conn;
path =Path.Combine
(Windows.Storage.ApplicationData.Current.LocalFolder.Path,"db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new
SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);

Upvotes: 6

Views: 7911

Answers (2)

mrri
mrri

Reputation: 83

C:\Users[Your User Name]\AppData\Local\Packages[Your Package Name]\LocalState

Your Package Name: You can find in file Package.appxmanifest in your Project Your file db.sqlite will in folder LocalState

Upvotes: 8

Glen Thomas
Glen Thomas

Reputation: 10744

If you go to

C:\Users\[YourUserName]\AppData\Local\Packages\

your application will have its own folder there, which you may be able to recognise by name or do a search for sqlite, and the SQLite database file should be within your applications folder

Upvotes: 7

Related Questions