I am trying to use .distinct in Linq to get the result based on one field of the table (so do not require whole duplicated records from the table).
I know writing a basic query using distinct as followed:
var query = (from r in table1
orderby r.Text
select r).distinct();
but I need results where r.text is not duplicated.