title: How to display data from multiple tables in a single gridview or gridpanel using linq2sql?
body: <p>I have two sql tables Department and Lecturer with:</p>
  
  <pre><code>Department: DepartmentID, Name
  Lecturer: LecturerID, Name, DepartmentID
  </code></pre>
  
  <p>I want to  show the data in a table with columns:</p>
  
  <pre><code>Lecturer ID, Name and Department Name
  </code></pre>
  
  <p>How can I achieve this using Linq to Sql( with or without lambda expression)? I really appreciate your help. Thank you.</p>