The N+1 Query Problem in EF Core (And How to Spot It Before Production Does)

A page that felt fine in testing is slow in production. Same code, same query, but now it crawls. You open the SQL log and there it is — not one query, but two hundred. One to load the list, then one