When I deploy the database file cannot be found. I have confirmed that the database file IS actually in the same folder as the exe for the app after the app is installed.base(@"metadata=DataModel1.csdl|DataModel1.ssdl|DataModel1.msl;provider=Devart.Data.SQLite;provider connection string=""Data Source=database.db;FailIfMissing=False""", "Entities")
I'd like to use the current user's appdata folder on deployment. That buries the database file in a less obvious location so less messing around by users and less possibility of accidental erasure.
Is there a way that Entity Developer's connection string can look in multiple places for a database file?
Also, I do not want to overwrite the database file once it has been installed and has been written to by the app. That would lose data.
What is the best strategy for an embedded resource like this with Entity Developer?