title: Many to many relation table and Linq query to join them
body: <p>I have the given scenario tables having Many to many relation between Departments and Rooms. There is also a junction.
  <a href="https://i.stack.imgur.com/F4gVN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F4gVN.jpg" alt="enter image description here"></a></p>
  
  <p>I have following class named DepartmentWithRoom </p>
  
  <pre><code>public class DepartmentWithRoom
  {
    public Guid DepartmentId { get; set; }
  
    public string DepartmentName { get; set; }
  
    public List&lt;Rooms&gt; RoomList { get; set; }
  }
  </code></pre>
  
  <p>Problem: I want to create a list of DepartmentWithRoom object having List of associated RoomId in it using Linq.</p>
  
  <p>I tried but not able to create the join. Please help Thanks in advance</p>