title: Using Inner joins in Entity Framework on multiple tables?
body: <p>I have a <code>student</code> table in my database with columns <code>Id, Name, DepartmentId, CollegeId, CityId</code> etc and a <code>Department</code> table, <code>College</code> table to map to the <code>DepartmentId</code>, <code>CollegeId</code> in the <code>Student</code> table.</p>
  
  <p>Now I want to pass <code>CityId</code> and retrieve <code>Id, Name, DepartmentName, CollegeName</code> with help of the corresponding tables using inner join based on the <code>CityId</code>.</p>
  
  <p>I'm implementing a method <code>FindAll()</code> which takes in <code>CityId</code> as the input parameter and retrieves data based on <code>CityId</code></p>
  
  <pre><code>  public IEnumerable&lt;StudentRegionEntity&gt; FindAll(int CityId)
    {
       var totalStudents = new List&lt;StudentRegionEntity&gt;();
  
       foreach(var entity in this.Dbcontext.Students)
       {
       }
    }
  </code></pre>
  
  <p>In the foreach loop I want to bind the list of students with <code>Id, Name, Department, College</code> fields, how can I use joins and implement the functionality for <code>FindAll()</code>?</p>