The C# language supports the following clauses that you can use in a query: : LINQ « LINQ « ASP.NET Tutorial

1. ASP.NET Tutorial
2. LINQ
3. LINQ

from, where, select, group, into, orderby, join, let

var results = from w in words
  where w.Contains("z")
  select w;


is translated into this query by the C# compiler:

var results = words.Where( w => w.Contains("z") ).Select( w => w );