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.

Generating these queries requires something like the SQL outer join and I walked through constructing that query in the column. I got some feedback from readers of that column who use the LINQ ...

If LINQ were smart enough-- and it's pretty smart in other areas, at least-- it'd be feasible to see certain of these operations pushed out to the database server in the SQL.