Use SQLite in .NET Core MVC and Publish to Azure
0:00 What is it?
2:40 Steps to Convert
5:30 Demo Steps 1 - 3
9:00 EF Core SQLite Limitations
12:30 Reset Migrations
13:40 TIMESTAMP Fix (Modify Migration)
18:00 Update Database to create the SQLite .db file
20:15 DbUpdateExecption Error Message Changes
21:20 Confirm Concurrency Works
22:20 Fix Error Message Issue
26:45 Publish To Azure
----------------------------------------------------------------------------------------
CORRECTION: You do not need to have a separate connection string for AZURE. The relative path in the LOCAL one works on Azure as well.
Convert our .NET Core MVC application from SQL Server LocalDB to SQLite in 3 or 4 simple steps. Then publish it to Azure without having to pay for SQL Server!