| 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. |
| Determines whether any element of a sequence exists or satisfies a condition. | |
| Returns the input typed as IEnumerable<T>. | |
| Computes the average of a sequence of numeric values. | |
| Converts the elements of an IEnumerable to the specified type. | |
| Concatenates two sequences. | |
| Determines whether a sequence contains a specified element. | |
| Returns the number of elements in a sequence. | |
| Returns the elements of an IEnumerable<T>, or a default valued singleton collection if the sequence is empty. | |
| Returns distinct elements from a sequence. | |
| Returns the element at a specified index in a sequence. | |
|
<TSource> |
Returns the element at a specified index in a sequence or a default value if the index is out of range. |
| Returns an empty IEnumerable<(Of <(T>)>) that has the specified type argument. | |
| Produces the set difference of two sequences. | |
| Returns the first element of a sequence. | |
| Returns the first element of a sequence, or a default value if no element is found. | |
| Groups the elements of a sequence. | |
| Correlates the elements of two sequences based on key equality, and groups the results. | |
| Produces the set intersection of two sequences. | |
|
Correlates the elements of two sequences based on matching keys. |
|
| Returns the last element of a sequence. | |
| Returns the last element of a sequence, or a default value if no element is found. | |
| Returns an Int64 that represents the number of elements in a sequence. | |
| Returns the maximum value in a sequence of values. | |
| Returns the minimum value in a sequence of values. | |
| Filters the elements of an IEnumerable based on a specified type. | |
| Sorts the elements of a sequence in ascending order. | |
| Sorts the elements of a sequence in descending order. | |
| Generates a sequence of integral numbers within a specified range. | |
| Generates a sequence that contains one repeated value. | |
| Inverts the order of the elements in a sequence. | |
| Projects each element of a sequence into a new form. | |
| Projects each element of a sequence to an IEnumerable<T> and flattens the resulting sequences into one sequence. | |
| Determines whether two sequences are equal according to an equality comparer. | |
| Returns a single, specific element of a sequence of values. | |
| Returns a single, specific element of a sequence of values, or a default value if no such element is found. | |
| Bypasses a specified number of elements in a sequence and then returns the remaining elements. | |
| Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. | |
| Computes the sum of a sequence of numeric values. | |
|
Take<TSource> |
Returns a specified number of contiguous elements from the start of a sequence. |
| Returns elements from a sequence as long as a specified condition is true, and then skips the remaining elements. | |
| Performs a subsequent ordering of the elements in a sequence in ascending order. | |
| Performs a subsequent ordering of the elements in a sequence in descending order. | |
| Creates an array from a IEnumerable<T>. | |
| Creates a Dictionary<TKey, TValue> from an IEnumerable<T>. | |
| Creates a List<T> from an IEnumerable<T>. | |
| Creates a generic Lookup<TKey, TElement> from an IEnumerable<T>. | |
| Produces the set union of two sequences. | |
| Filters a sequence of values based on a predicate. |
Linq on Wikipedia
One Comment
i want that memorize programing