how to use distinct in linq query in c# code example

Example 1: C# .NET Core linq Distinct

var distinctUsers = allUsers
    .GroupBy(x => x.UserId)
    .Select(x => x.First())
    .ToList();

Example 2: how to use distinct in linq query in c#

var distValues = objList.Select(o=>o.typeId).Distinct().ToList();

Example 3: 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 4: select distinct linq mvc

public static IQueryable GetDistinctProdType(
    this IQueryable query,
    int categoryId)
{
    return (from p in query
            where p.CatID == categoryId
            select p.Type).Distinct();
}

Tags:

Misc Example

Related