The query syntax is translated to the regular method call syntax (through a pure syntax transformation). So everything in the query syntax is representable in method form. The reverse is not true.

Peter follows up -- yet again – on a column on how to group results with LINQ using the SQL-like syntax with the same solution using the method-based syntax. And, no, you're not seeing double.

Peter follows up on advice for joining collections with LINQ and getting all of the results, but this time, he uses the method-based syntax.

I'm comfortable writing SQL and I'm comfortable with method chaining in LINQ, but I am not comfortable writing in the query syntax style of LINQ.

BIRCH: There are two primary benefits that I enjoy when using LINQ to SQL, the first one being the ease of transition for people moving from standard T-SQL query syntax to this new method of data ...