OverviewSequence→SequenceFilteringProjectingJoiningOrderingGroupingSet operatorsZip operatorConversion methods: ImportConversion methods: ExportSequence→Element or ScalarElement operatorsAggregation methodsQuantifiersVoid→SequenceGeneration methodsFilteringWhereQuery syntaxEnumerable.Where implementationOverviewIndexed filteringSQL LIKE comparisons in LINQ to SQL and EF< and > string comparisons in LINQ to SQL and EFWHERE x IN (..., ..., ...) in LINQ to SQL and EFTake and SkipTakeWhile and SkipWhileDistinctProjectingSelectQuery syntaxEnumerable implementationOverviewIndexed projectionSelect subqueries and object hierarchiesSubqueries and joins in LINQ to SQL and EFProjecting into concrete typesSelectManyQuery syntaxEnumerable implementationOverviewOuter range variablesThinking in query syntaxJoining with SelectManySelectMany in LINQ to SQL and EFOuter joins with SelectManyJoiningJoin and GroupJoinJoin argumentsGroupJoin argumentsQuery syntaxOverviewJoinJoining on multiple keysJoining in fluent syntaxGroupJoinFlat outer joinsJoining with lookupsEnumerable implementationsOrderingOrderBy, OrderByDescending, ThenBy, and ThenByDescendingOrderBy and OrderByDescending argumentsThenBy and ThenByDescending argumentsQuery syntaxOverviewComparers and collationsIOrderedEnumerable and IOrderedQueryableGroupingGroupByQuery syntaxOverviewGroupBy in LINQ to SQL and EFGrouping by multiple keysCustom equality comparersSet OperatorsConcat and UnionIntersect and ExceptThe Zip OperatorConversion MethodsOfType and CastToArray, ToList, ToDictionary, and ToLookupAsEnumerable and AsQueryableElement OperatorsFirst, Last, and SingleElementAtDefaultIfEmptyAggregation MethodsCount and LongCountMin and MaxSum and AverageAggregateUnseeded aggregationsTraps with unseeded aggregationsQuantifiersContains and AnyAll and SequenceEqualGeneration MethodsEmptyRange and Repeat