Answers for "linq select distinct"

SQL
1

c# linq select only unique values from list

var uniq = allvalues.GroupBy(x => x.Id).Select(y=>y.First()).Distinct();
Posted by: Guest on November-17-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
1

c# linq select only unique values from list

var uniqueCategories =  repository.GetAllProducts()
                                  .Select(p=>p.Category)
                                  .Distinct();
Posted by: Guest on November-17-2020
6

query DISTINCT

SELECT DISTINCT Column_name FROM table_name;
Posted by: Guest on April-14-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
0

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();
}
Posted by: Guest on March-05-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language