This post assumes you’ve read the previous posts in this series:
         Converting SQL to LINQ, Part 1: The Basics
         Converting SQL to LINQ, Part 2: FROM and SELECT
         Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators
         Converting SQL to LINQ, Part 4: ...