I am deploying the .NET/WPF application that uses SQLite database as back-end and Entity Framework for CRUD operations with that file.
I want that the end users after installing the application will have that SQLite file on they local computer (is it /Users/xxxx/AppData/Roaming/MyApp or something else ?).
During the development I have had the SQLite file located on my local folder and everything has worked fine. How do I configure the application before deploying it to get that result?
I found a great answer from another question: %APPDATA% in connection string is not substituted for the actual folder?
What was needed was:
Providing the value for |DataDirectory| in the application Main method