I recently posted a video on www.gridviewguy.com in which I talked about LINQ TO SQL INNER AND LEFT OUTER JOINS. The fun thing about this video is that I tackled the problem from both sides. This means first the query is created using pure T-SQL and then then it is generated using LINQ TO SQL. Check out the video using the link below:
Video