Entity Framework Core and migrations

Entity Framework Core (EF Core) maps C# classes to database tables through a DbContext. It has one DbSet<Order> per table. Relationships are defined with navigation properties or the fluent API.

You query with LINQ, and EF Core turns it into SQL. For schema changes, dotnet ef migrations add AddOrderStatus generates a migration from your model changes. dotnet ef database update applies it.

In production, generate an idempotent SQL script (safe to run twice) or a migration bundle, and run it as a deploy step. Read what each migration does, especially renames.