title: Linq to get complete row based on duplicate values in column
body: <p>I am looking for a LINQ to use with my datatable and display all the duplicate rows based on certain columns in windows form datagrid view.</p>
  
  <p>The LINQ should give a result similar to the plain old below give SQL.</p>
  
  <pre><code>SELECT *
  FROM Table1 t
  JOIN (  SELECT Taskid, Studentid, DateChangeid
        FROM Table1
        GROUP BY Taskid, studentid, datechangeid
        HAVING COUNT(*) &gt; 1) temp
    ON t.taskid = temp.taskid AND t.studentid= temp.studentid AND t.datechangeid= temp.datechangeid
  </code></pre>