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. The implementation should be justified by measurable requirements, kept as simple as the problem allows, and validated with realistic tests, telemetry, failure handling, and documented tradeoffs.