What is projection to DTOs in Entity Framework Core?

Projection uses Select to shape query results directly into DTOs or anonymous types. 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.