How should eager, explicit, and lazy loading be designed for production in Entity Framework Core?

Prefer projections or targeted eager loading, inspect generated SQL, and avoid loading unnecessary graphs.