Downside of LINQ

 

1. Operators like Orderby are greedy, when used execution is no longer lazy.
2. You have to pay more attention to LINQ queries for remote data
3. If you use Count on LINQ query and also use the same query in foreach, then you end up iterating over the dataset twice.
4. no edit and continue support