Language Integrated Query adds declarative query operators to any IEnumerable<T> (in memory) or IQueryable<T> (translated to SQL by Entity Framework). Category Operators Filter Where, OfType, Distinct, DistinctBy Project Select, SelectMany Sort OrderBy, ThenByDescending, Order (.NET 7) Group / join GroupBy, Join, GroupJoin, ToLookup Aggregate Count, Sum, Average, Min/MaxBy, Aggregate, CountBy (.NET 9) Element First(OrDefault), Single, Last, ElementAt Quantify Any, All, Contains Partition Take, Skip, TakeWhile, Chunk Materialise ToList, ToArray, ToDictionary, ToHashSet Deferred execution Most operators are lazy — the query runs when you enumerate it (foreach, ToList()). Enumerating twice runs it twice; call ToList() once if you reuse results.