How can you customize migrations (e.g. modify Up/Down methods, custom SQL)?

Short answer: You can manually edit migration files after scaffolding: protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.Sql("UPDATE Users SET IsActive = 1 WHERE IsActive IS NULL"); } Add indexes, constraints, stored procedures. Use raw SQL or Fluent API. Be cautious to maintain idempotency and correctness. Entity Framework Core – Change Tracking & Concurrency

Real-world example (ShopNest)

When ShopNest adds a DiscountCode column, you create a migration, review the SQL, then apply it on staging before production.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.