I'm trying to include a SQLite file with the UWP application. SQLite file has a number of tables in it populated with data.
The database (for now, at least) is read-only and I'm planning to use EF Core to access the data.
So i have two questions:
Setting .sqlite file's "Copy to output directory" setting to "Copy always" seems to copy the file to bin folder but I can't seem to figure out the path to access it. When setting the SQLite conenction string to "Filename=databasename.sqlite" - it seems to create a blank DB file elsewhere, as tryign to access any of the tables throws a table not found exception.
Thanks in advance!
My recommendation is ...
I've answered for the similar question on MSDN forum. Please refer it too.