linq get distinct from table code example
Example 1: how to use distinct in linq query in c#
var distValues = objList.Select(o=>o.typeId).Distinct().ToList();
Example 2: linq distinct
var uniquePeople = from p in people
group p by new {p.ID} //or group by new {p.ID, p.Name, p.Whatever}
into mygroup
select mygroup.FirstOrDefault();