LINQ Standard Query Operators Cheat Sheet
Posted in Development
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!
7 comments
Milan Negovan
on December 19, 2007
"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.
Roger Jennings
on December 28, 2007
Pingback from http://oakleafblog.blogspot.com/2007/12/linq-and-entity-framework-posts-for_24.html
Zeeshan Hirani
on December 29, 2007
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!
.
on December 10, 2008
Thank you, an excellent resource. Is there any chance of adding the IEnumerable Members?
Milan Negovan
on December 10, 2008
Well, IEnumerable is extended with these static methods.
.
on December 14, 2008
The XNode methods are all missing, e.g. Remove http://msdn.microsoft.com/en-us/library/bb357554.aspx
Jay R. Wren
on December 17, 2007
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...