# Queryable Members

**.NET Framework 3.5**

Provides a set of static (Shared in Visual Basic) methods for querying data structures that implement IQueryable<T>.

The Queryable type exposes the following members.

Name | Description | |
---|---|---|

Aggregate | Overloaded. Applies an accumulator function over a sequence. | |

All<TSource> | Determines whether all the elements of a sequence satisfy a condition. | |

Any | Overloaded. Determines whether any element of an IQueryable<T> sequence exists or satisfies a condition. | |

AsQueryable | Overloaded. Converts an IEnumerable or generic IEnumerable<T> to an IQueryable or generic IQueryable<T>. | |

Average | Overloaded. Computes the average of a sequence of numeric values. | |

Cast<TResult> | Converts the elements of an IQueryable to the specified type. | |

Concat<TSource> | Concatenates two sequences. | |

Contains | Overloaded. Determines whether an IQueryable<T> contains a specified element. | |

Count | Overloaded. Returns the number of elements in a sequence. | |

DefaultIfEmpty | Overloaded. Returns the elements in a sequence or a default valued singleton collection if the sequence is empty. | |

Distinct | Overloaded. 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. | |

Except | Overloaded. Produces the set difference of two sequences. | |

First | Overloaded. Returns the first element of a sequence. | |

FirstOrDefault | Overloaded. Returns the first element of a sequence, or a default value if no element is found. | |

GroupBy | Overloaded. Groups the elements of a sequence. | |

GroupJoin | Overloaded. Correlates the elements of two sequences based on key equality and groups the results. | |

Intersect | Overloaded. Produces the set intersection of two sequences. | |

Join | Overloaded. Correlates the elements of two sequences based on matching keys. | |

Last | Overloaded. Returns the last element in a sequence. | |

LastOrDefault | Overloaded. Returns the last element of a sequence, or a default value if no element is found. | |

LongCount | Overloaded. Returns an Int64 that represents the number of elements in sequence. | |

Max | Overloaded. Returns the maximum value in a sequence. | |

Min | Overloaded. Returns the minimum value in a sequence. | |

OfType<TResult> | Filters the elements of an IQueryable based on a specified type. | |

OrderBy | Overloaded. Sorts the elements of a sequence in ascending order. | |

OrderByDescending | Overloaded. Sorts the elements of a sequence in descending order. | |

Reverse<TSource> | Inverts the order of the elements in a sequence. | |

Select | Overloaded. Projects each element of a sequence into a new form. | |

SelectMany | Overloaded. Projects each element of a sequence to an IEnumerable<T> and combines the resulting sequences into one sequence of type IQueryable<T>. | |

SequenceEqual | Overloaded. Determines whether two sequences are equal. | |

Single | Overloaded. Returns a single, specific element of a sequence. | |

SingleOrDefault | Overloaded. Returns a single, specific element of a sequence, 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 | Overloaded. Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. | |

Sum | Overloaded. 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 | Overloaded. Returns elements from a sequence as long as a specified condition is true, and then skips the remaining elements. | |

ThenBy | Overloaded. Performs a subsequent ordering of the elements in a sequence in ascending order. | |

ThenByDescending | Overloaded. Performs a subsequent ordering of the elements in a sequence in descending order. | |

Union | Overloaded. Produces the set union of two sequences. | |

Where | Overloaded. Filters a sequence of values based on a predicate. |

## Community Additions

ADD
Show: