Below is a link to Kevin's presentation that he did for us RSSUG on May 8th 2008, Profiling and Tuning LINQ Queries. Sorry it took so long to get updated on the site, Kevin was busy then I was busy...here you go.
http://www.gotnet.biz/Blog/post/Profiling-LINQ-Queries-Presentation.aspx
The link has both the powerpoint slides and the #C code.