title: MVC EF LINQ - Distinct not working
body: <p>I have the following query expecting to retrieve only unique values from the entity according the selected School:</p>
  
  <pre><code>var semesters = (from cou in db.Courses
      join sem in db.Semesters on cou.SemesterID equals sem.ID
      where cou.FacultyID == id 
      select new SemestersModel {
          SemesterID = sem.ID,
          SemesterText = sem.Semester })
      .Distinct()
      .ToList();
  </code></pre>
  
  <p>However it returns all semesters contained in the entity Courses</p>
  
  <ul>
  <li>Semester 1,  Semester 1,  Semester 1, Semester 2, Semester 2  ...etc.
  etc.</li>
  </ul>
  
  <p>Please help me to grab only distinct semester names e.g. </p>
  
  <ul>
  <li>Semester 1,  Semester 2,  etc.</li>
  </ul>
  
  <p>P.S. my issue is different than this one <a href="https://stackoverflow.com/questions/14321013/distinct-in-linq-based-on-only-one-field-of-the-table">Distinct in Linq based on only one field of the table</a> </p>