Linq .NET 3.5 Set Operations – Quick Reference


from	Specifies a data source and a range variable (similar to an iteration variable).
where	Filters source elements based on one or more Boolean expressions separated by logical AND and OR operators ( && or \|\| ).
select	Specifies the type and shape that the elements in the returned sequence will have when the query is executed.
group	Groups query results according to a specified key value.
into	Provides an identifier that can serve as a reference to the results of a join, group or select clause.
orderby	Sorts query results in ascending or descending order based on the default comparer for the element type.
join	Joins two data sources based on an equality comparison between two specified matching criteria. from category in categories join prod in products on category.ID equals prod.CategoryID select new { ProductName = prod.Name, Category = category.Name };
let	Introduces a range variable to store sub-expression results in a query expression.
in	Contextual in a join
on	Contextual in a join
equals	Contextual in a join
by	Contextual in a group
ascending	Contextual in an orderby
descending	Contextual in an orderby

Aggregate	Applies an accumulator function over a sequence.
All<TSource>	Determines whether all elements of a sequence satisfy a condition.
Any	Determines whether any element of a sequence exists or satisfies a condition.
AsEnumerable<TSource>	Returns the input typed as IEnumerable<T>.
Average	Computes the average of a sequence of numeric values.
Cast<TResult>	Converts the elements of an IEnumerable to the specified type.
Concat<TSource>	Concatenates two sequences.
Contains	Determines whether a sequence contains a specified element.
Count	Returns the number of elements in a sequence.
DefaultIfEmpty	Returns the elements of an IEnumerable<T>, or a default valued singleton collection if the sequence is empty.
Distinct	Returns distinct elements from a sequence.
ElementAt<TSource>	Returns the element at a specified index in a sequence.
ElementAtOrDefault <TSource>	Returns the element at a specified index in a sequence or a default value if the index is out of range.
Empty<TResult>	Returns an empty IEnumerable<(Of <(T>)>) that has the specified type argument.
Except	Produces the set difference of two sequences.
First	Returns the first element of a sequence.
FirstOrDefault	Returns the first element of a sequence, or a default value if no element is found.
GroupBy	Groups the elements of a sequence.
GroupJoin	Correlates the elements of two sequences based on key equality, and groups the results.
Intersect	Produces the set intersection of two sequences.
Join	Correlates the elements of two sequences based on matching keys.
Last	Returns the last element of a sequence.
LastOrDefault	Returns the last element of a sequence, or a default value if no element is found.
LongCount	Returns an Int64 that represents the number of elements in a sequence.
Max	Returns the maximum value in a sequence of values.
Min	Returns the minimum value in a sequence of values.
OfType<TResult>	Filters the elements of an IEnumerable based on a specified type.
OrderBy	Sorts the elements of a sequence in ascending order.
OrderByDescending	Sorts the elements of a sequence in descending order.
Range	Generates a sequence of integral numbers within a specified range.
Repeat<TResult>	Generates a sequence that contains one repeated value.
Reverse<TSource>	Inverts the order of the elements in a sequence.
Select	Projects each element of a sequence into a new form.
SelectMany	Projects each element of a sequence to an IEnumerable<T> and flattens the resulting sequences into one sequence.
SequenceEqual	Determines whether two sequences are equal according to an equality comparer.
Single	Returns a single, specific element of a sequence of values.
SingleOrDefault	Returns a single, specific element of a sequence of values, or a default value if no such element is found.
Skip<TSource>	Bypasses a specified number of elements in a sequence and then returns the remaining elements.
SkipWhile	Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.
Sum	Computes the sum of a sequence of numeric values.
Take<TSource>	Returns a specified number of contiguous elements from the start of a sequence.
TakeWhile	Returns elements from a sequence as long as a specified condition is true, and then skips the remaining elements.
ThenBy	Performs a subsequent ordering of the elements in a sequence in ascending order.
ThenByDescending	Performs a subsequent ordering of the elements in a sequence in descending order.
ToArray<TSource>	Creates an array from a IEnumerable<T>.
ToDictionary	Creates a Dictionary<TKey, TValue> from an IEnumerable<T>.
ToList<TSource>	Creates a List<T> from an IEnumerable<T>.
ToLookup	Creates a generic Lookup<TKey, TElement> from an IEnumerable<T>.
Union	Produces the set union of two sequences.
Where	Filters a sequence of values based on a predicate.

Linq on Wikipedia

Technorati Tags: Linq to Objects,Linq,Expressions,Enumerable,IEnumerable<T>,C#,.NET 3.5,Fluent API

pushbomb

Linq .NET 3.5 Set Operations – Quick Reference

One Comment

Post a Comment

Twitter Updates

Recent Posts

Flickr Photos

Meta