Answers for "linq distinct example"

SQL
3

C# .NET Core linq Distinct

var distinctUsers = allUsers
    .GroupBy(x => x.UserId)
    .Select(x => x.First())
    .ToList();
Posted by: Guest on June-30-2020
0

how to use distinct in linq query in c#

var distValues = objList.Select(o=>o.typeId).Distinct().ToList();
Posted by: Guest on February-04-2021
6

query DISTINCT

SELECT DISTINCT Column_name FROM table_name;
Posted by: Guest on April-14-2020
0

c# distinct comparer multiple properties

public static IEnumerable<TSource> DistinctBy<TSource, TKey>
    (this IEnumerable<TSource> source, Func<TSource, TKey> keySelector)
{
    HashSet<TKey> seenKeys = new HashSet<TKey>();
    foreach (TSource element in source)
    {
        if (seenKeys.Add(keySelector(element)))
        {
            yield return element;
        }
    }
}
Posted by: Guest on April-19-2020
0

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();
Posted by: Guest on January-11-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language