how to make a good database on code first entity framework core code example
Example: how to generate entities from an existing database in entityframework core
PM> Scaffold-DbContext "Server=.\SQLExpress;Database=SchoolDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models