What is eager, explicit, and lazy loading in Entity Framework Core?

Related data can be loaded eagerly with Include, explicitly on demand, or lazily when proxies are enabled. 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.