What is a common mistake with Any, All, and Contains in LINQ?

Using Count() > 0 for existence can do unnecessary work and is less expressive than Any. 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.