EF6 vs EF Core migration
What should you verify when migrating Entity Framework 6 (.NET Framework) to EF Core?
Answers use simple, clear English.
Quick interview answer
LINQ translation differences, lazy loading defaults, transaction APIs, raw SQL methods (ExecuteSqlRaw), spatial/types support, migrations workflow, and performance of Include vs split queries. Run golden query tests. EDMX designer isn't the Core path — use code-first/fluent config.
Detailed answer
LINQ translation differences, lazy loading defaults, transaction APIs, raw SQL methods (ExecuteSqlRaw), spatial/types support, migrations workflow, and performance of Include vs split queries. Run golden query tests. EDMX designer isn't the Core path — use code-first/fluent config. Some EF6 features need redesign.
Real example & use case
Replace Database.BeginTransaction patterns; add AsNoTracking for read APIs.
Pros & cons
Pros: speed + cross-platform. Cons: subtle query behavior changes.