linq select distinct code example
Example 1: c# linq select only unique values from list
var uniq = allvalues.GroupBy(x => x.Id).Select(y=>y.First()).Distinct();
Example 2: c# linq select only unique values from list
var uniqueCategories = repository.GetAllProducts()
.Select(p=>p.Category)
.Distinct();
Example 3: query DISTINCT
SELECT DISTINCT Column_name FROM table_name;
Example 4: how to use distinct in linq query in c#
var distValues = objList.Select(o=>o.typeId).Distinct().ToList();
Example 5: 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();
Example 6: select distinct linq mvc
public static IQueryable<ProdType> GetDistinctProdType(
this IQueryable<ProdInfo> query,
int categoryId)
{
return (from p in query
where p.CatID == categoryId
select p.Type).Distinct();
}