LINQ provides an API known as standard query operators (SQOs) to support the kinds of operations we're accustomed to in SQL. You've already used C#'s select and where keywords, which map to LINQ's Select and Where SQOs—which, like all SQOs, are actually methods of the System.Linq.Enumerable static class. Table 1-1 is a complete listing of SQOs.
|Aggregate||Aggregate||Applies a function over a sequence|
|Average||Calculates the average over a sequence|
|Count/LongCount||Counts the element of a sequence|
|Max||Returns the maximum value from a sequence of numeric values|
|Min||Returns the minimum value from a sequence of numeric values|