title: MVC EF - Inner Join
body: <p>I checked the questions that may already have my answer but it seems that none of them addresses the issue I have:</p>
  
  <pre><code>var semesters = db.Semesters.Where(e =&gt; e.ID == semester).ToList();
  var semestersbyfaculty = db.SemestersByFaculty.Where(e =&gt; e.FacultyID == id).ToList();
  </code></pre>
  
  <p>How do I inner join these two queries like if I do the following in SQL:</p>
  
  <pre><code>SELECT 
     Fac.*, Sem.SemesterText
  FROM 
     SemestersByFaculty AS Fac
  INNER JOIN
     Semesters AS Sem
  ON
     Fac.SemesterID = Sem.ID
  WHERE id
     Fac.FacultyID = id
  </code></pre>