ASP.NET Core 2.0 Web Application fails with a SQLite error when deploying the project to Azure Web Service but runs fine in local environment

Question

The ASP.NET Core 2.0 web application fails when I deploy it to Azure App Service.

This is what is being used in the project.

ASP.NET Core 2.0 MVC Web Application
Visual Studio 2017 Enterprise
SQLite databases
Code First Entity Framework
Azure App Service

The web application works fine when I run it locally in Visual Studio. The problem results when I publish it to an Azure Web Service it cannot connect to the database. It states the following error when navigating to the deployed web application URL:

SqliteException: SQLite Error 1: 'no such table: Inventory'.

I've tried several times to apply an Update-Migration or an Add-Migration to the database but it will still result in the table not found when deployed to the Azure server.

Here are my SQLite connections defined in the Startup.cs file.

     // Add Inventory DB
        services.AddDbContext<InventoryContext>(options =>
        options.UseSqlite("Data Source=Inventory.db"));

        // Add User DB
        services.AddDbContext<UserContext>(options =>
        options.UseSqlite("Data Source=User.db"));

        // Add Purchase Order DB
        services.AddDbContext<PurchaseOrderContext>(options =>
        options.UseSqlite("Data Source=PurchaseOrder.db"));

Yes, put the SQLite databases in the "AppData" folder in the .NET Solution directory and point your connection strings to that new location — Derek Coppinger
– Derek Coppinger, Commented Mar 19, 2018 at 1:13
@EmmanuelOgoma Were you able to resolve the problem you were having? — Derek Coppinger
– Derek Coppinger, Commented Apr 3, 2018 at 15:11

Jonathan Ramos · Accepted Answer · 2019-11-02 02:25:14Z

2

Following @Derek solution, i modified my connection string on appsettings.json as i am using Configuration.GetConnectionString to fetch the connection string, and moved sqlite db to App_Data folder to wwwroot..

"ConnectionStrings": {
    "MyAppContext": "Data Source=./wwwroot/App_Data/myapp.db"
}

answered Nov 2, 2019 at 2:25

Jonathan Ramos

2,2111 gold badge21 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Derek Coppinger · Accepted Answer · 2018-12-19 18:44:24Z

0

Place the SQLite databases in the "AppData" folder in the .NET Solution directory and point your connection strings to that new location.

answered Dec 19, 2018 at 18:44

Derek Coppinger

491 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

ASP.NET Core 2.0 Web Application fails with a SQLite error when deploying the project to Azure Web Service but runs fine in local environment

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related