What is a common mistake with ordering and pagination in LINQ?

Paginating without a unique tie-breaker can produce duplicates or missing rows between requests. 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.