csharp-linq

Deferred execution in LINQ to Objects means query evaluation is postponed until results are explicitly iterated. This Skill clarifies materialization timing to help you avoid repeated enumeration and unintended side effects in in-memory collections.

Call ToList or ToArray to materialize queries when you need multiple passes or repeated iteration over in-memory collections. This Skill provides actionable recommendations on when materialization is necessary versus when preserving deferred execution is more efficient.

Using Any over Count for existence checks improves LINQ performance because Any stops evaluating at the first match. This Skill recommends proper operator selection to enforce correctness and optimize in-memory collection query efficiency.

SelectMany is the correct LINQ operator for flattening nested collections into a single sequence. This Skill clarifies projection versus flattening operator semantics to ensure you use SelectMany correctly instead of misusing Select during code review.

No, this Skill explicitly focuses on LINQ to Objects and code review scenarios outside EF Core. It analyzes in-memory collection queries, addressing repeated enumeration, grouping memory costs, and side effects rather than database translation.

Avoid side effects in LINQ projections by ensuring Select and other operators do not mutate external state during deferred execution. This Skill reviews in-memory queries to identify hidden side effects and enforce readable, correct LINQ chaining.