Data access: EF Core best practices (no tracking, lazy loading,?

Short answer: migrations) Use No Tracking queries for read-only data to improve performance. Use lazy loading cautiously; prefer explicit loading to avoid surprises. Manage migrations with proper version control. Use async queries to avoid blocking.

Real-world example (ShopNest)

ShopNest registers AppDbContext as Scoped and IMemoryCache as Singleton. Putting DbContext in a Singleton causes threading bugs.

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.