Issue with Blazor App Deployment: SQLite Table Missing and Pending Migrations

Question

Hi
I’ve created a Blazor 8 application using Scaffolder and SQLite in Visual Studio. I followed the steps provided in this tutorial https://youtu.be/tSUwr-R1JPQ. The application works fine when running on localhost, but when I try to deploy it, I encounter the error: SqliteException: SQLite Error 1: 'no such table: Book'.

Why does the application work correctly on localhost but face issues upon deployment? How can I resolve the connection string issue and apply the migrations successfully?

Thank you very much for your help.

Answer 1

Did you deploy the SQLite file with the application?

Try clicking on the SQLite file in solution explorer. In the properties window make sure Copy to Output Directory is set to "Copy always". Then try redeploying the application.