What is a common mistake with IEnumerable versus IQueryable in LINQ?

Calling ToList or AsEnumerable too early can load far more data than necessary. 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.