title: Filter list having two Tables join data in Entity Framework
body: <p>I have two tables..</p>
  
  <pre><code>Student (StudentId,Name,FatherName)
  Qualification (QualificationId,StudentId,DegreeName)
  </code></pre>
  
  <p>I have got data like this..</p>
  
  <pre><code>var myList = (from c in entities.Students
                join q in entities.Qualifications on c.StudentId equals  q.StudentId
                select new {c.Name,c.FatherName,q.DegreeName}).ToList();
  </code></pre>
  
  <p>Now i want to filter myList more.. How can i do it, like..</p>
  
  <pre><code>var filteredList = myList.Select(c=&gt; new Student 
  {
  Name=c.Name,
  FatherName=c.FatherName
  //Degree=C.Degree
  }).ToList();
  </code></pre>
  
  <p>The above <code>Linq</code> Query is not working if i want to get DegreeName also, My Question is how to further Filter <code>myList</code>.
  Thanks.</p>