Create a new sqlite database at startup using C# Entity Framework Core in Visual Studio IDE. I demo this by creating a SQLite database that stores countries and airports in 2 tables.
Additional topics:
Seeding database tables
Changing foreign key delete behavior
Add navigation property to link related tables.
Visual Studio 22 / .NET 8.0
0:00 Intro
0:13 Nuget Database Provider
0:26 Map Classes
0:58 DbContext Setup
1:34 Startup
2:13 Insert, Update, Delete, Read
.cs files:
https://drive.google.com/drive/folder...