LINQ Standard Query Operators Cheat Sheet

Lately, I’ve been spending a lot of time with LINQ retrofitting custom collections of days past to become LINQ-ified. I dug through the somewhat outdated articles on MSDN, blogs and 101 LINQ Samples (outdated as well) to wrap my head around LINQ.

To save you (and myself) roundtrips to Google, I compiled a “cheat sheet” of the LINQ Standard Query Operators which you can download here (or click the image below):

Why SQO? They make more sense to me, a C# developer, than the SQL-looking query expressions. Just a matter of personal preference.

Enjoy and let me know if anything is amiss!

not LINQ IMO.

Instead this should be called "Enumerable static members quick reference"

There is nothing about C# or VB.NET language syntax in the whole helper, which is what LINQ is.

There is no reference to LINQ syntax. from x in y select z
let z=1
select q

etc...

"There is nothing about C# or VB.NET language syntax in the whole helper"

I don't follow you. This *is* language syntax. Look at the docs again:

"The standard query operators are the methods that form the Language-Integrated Query (LINQ) pattern"

What you're talking about are query expressions (not operators)which is "syntactic sugar" on top of this.

Pingback from http://oakleafblog.blogspot.com/2007/12/linq-and-entity-framework-posts-for_24.html

This is exactly what i needed to do quick look ups. I really got tired of opening up the book everytime time or looking. finally a good resource that would stay with me for years.

good work!