MVC EF - Inner Join
<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>