select distinct linq mvc
Code Example - 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();
}
csharp .NET Core linq Distinct
var distinctUsers = allUsers
.GroupBy(x => x.UserId)
.Select(x => x.First())
.ToList();
how to use distinct in linq query in csharp
var distValues = objList.Select(o=>o.typeId).Distinct().ToList();
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();
csharp linq select only unique values from list
var uniq = allvalues.GroupBy(x => x.Id).Select(y=>y.First()).Distinct();
query DISTINCT
SELECT DISTINCT Column_name FROM table_name;
linq select distinct
var _dbLogList = (from d in _context.pu_Synchronize_Log
join cd in _context.pu_Synchronize_Child_Log
on d.Synchronize_Log_Id equals cd.Synchronize_Log_Id
where cd.Mobile_Device_Id == preference.DId && cd.Synchronize_Status == "OPEN"
&& !d.Is_Deleted && !cd.Is_Deleted
select new
{
d.Service_Name,
}).Distinct().ToList();