Chandradev's Blog

LINQ supports the following clauses that you can use in a query:

1. from—Enables you to specify the data source and a variable for iterating over the

data source (a range variable).

2.where—Enables you to filter the results of a query.

3.select—Enables you to specify the items included in the results of the query.

4.group—Enables you to group related values by a common key.

5.into—Enables you to store the results of a group or join into a temporary variable.

6.orderby—Enables you to order query results in ascending or descending order.

7.join—Enables you to join two data sources using a common key.

8.let—Enables you to create a temporary variable to represent subquery results.

List of some of the more interesting and useful methods  in LINQ:

. Aggregate()—Enables you to apply a function to every item in a sequence.

. Average()—Returns the average value of every item in a sequence.

. Count()—Returns the count of items from a sequence.

. Distinct()—Returns distinct items from a sequence.

. Max()—Returns the maximum value from a sequence.

. Min()—Returns the minimum value from a sequence.

. Select()—Returns certain items or properties from a sequence.

. Single()—Returns a single value from a sequence.

. Skip()—Enables you to skip a certain number of items in a sequence and return the remaining elements.

. Take()—Enables you to return a certain number of elements from a sequence.

. Where()—Enables you to filter the elements in a sequence.