title: Remove Duplicate based on column value-linq
body: <p>i have many to many relationship between employee and group.  following linq statement</p>
  
  <pre><code>int[] GroupIDs = {6,7};
  
  
  var result = from g in umGroups
      join empGroup in umEmployeeGroups on g.GroupID equals empGroup.GroupID
      where  GroupIDs.Contains(g.GroupID)                     
      select new {  GrpId = g.GroupID,EmployeeID = empGroup.EmployeeID };
  </code></pre>
  
  <p>returns groupid and the employeeid. and result is</p>
  
  <pre><code>GrpId  | EmployeeID
  6      |   18
  6      |   20  
  7      |   19
  7      |   20
  </code></pre>
  
  <p>I need to remove the rows for which the employeeid is repeating e.g. any one of the row with employeeid= 20
  <br/>Thanks</p>