IQueryable vs IEnumerable: The Mistake That Loads Your Whole Table

You wrote a clean LINQ query. It filters down to ten rows. It runs fine in dev, and then in production it's slow and your database CPU is higher than it should be for such a small result. The query lo