Unable to find sqlite database after publish .Net core 2.0

Emanuele Leoni

I developed a .NET core MVC app running on Raspberry, but when I publish it for Ubuntu Mate,

dotnet publish -c Release -r ubuntu.16.04-arm

I can't find my sqlite Database although I have set datasource like this:

"Data Source=database.sqlite;"

The app works fine and communicates with the database. Is it correct or am I wrong anything?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Catcher Wong8y ago
Accepted answer
Hi emanuele,

If your app can works well, and your configuration is same as the following, database file should exist in the root of your publish folder.
Data Source=database.sqlite;
0
Emanuele Leoni8y ago
Hi Wong,
but my app works fine and reads/writes on db.
How can is it possible?
0
Catcher Wong8y ago
Hi emanuele,

I think the database file will not exist in the publish folder. You need to copy the database file to publish folder by yourself.

Hope this can help you!
0
Emanuele Leoni8y ago
Hi Wong,
I tried to find it in all the folders in /bin/Release/netcoreapp2.0/ubuntu.16.04-arm, but there wansn't.
Can you confirm that it should be in one of those folders?

Many thanks,
emanuele
0
Catcher Wong8y ago
Check whether the database file in your publish folder!
+2