What is a common mistake with LINQ in C#?

A common mistake is repeatedly enumerating an expensive sequence or loading large data sets before filtering. Understand deferred execution and the underlying provider.