This post isn't really a blog post as such, I thought as I watch
all the LINQ videos and read various websites I would document
useful bits of information that I can reference millions of times
over the next 2 years few months.
I am going to be adding to this page more and more over the
coming weeks too, to save having lots of different [more]
LINQ Clauses you can use in a query
- from - Enables you to specify the data source
and a variable for iterating over the data source (a range
variable)
- where - Enables you to filter the results of a
query
- select - Enables you to specify the items
included in the results of the query
- group - Enables you to group related values by
a common key
- into - Enables you to store the results of a
group or join into a temporary variable
- orderby - Enables you to order query results
in ascending or descending order
- join - Enables you to join two data sources
using a common key
- let - Enables you to create a temporary
variable to represent sub query results
Useful Enumerable methods (
Full list)
- 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 in a
sequence
- Distinct() - Returns distinct items in a
sequence
- Max() - Returns the maximum value from a
sequence
- Min() - Returns the minimum value from a
sequence
- Select() - Returns a single value 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