Quote from Eben Monney on February 22, 2018, 6:41 am

Please refer to this article on how to use Sqlite in an EntityFrameworkCore project: https://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite

The points to look out for are:

1. Running "dotnet add package Microsoft.EntityFrameworkCore.Sqlite" to add Microsoft.EntityFrameworkCore.Sqlite to the Web projects .csproj file. You can also add this manually by editing the .csproj file.
2. Changing this line in Startup.cs from "options.UseSqlServer(Configuration["ConnectionString…" to "options.UseSqlite(Configuration["ConnectionString…"

For additional insight see this blog post: https://elanderson.net/2017/04/entity-framework-core-with-sqlite/