What is a common mistake with projection to DTOs in Entity Framework Core?

Loading full entities and mapping them in memory wastes resources for list and reporting endpoints. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.