62,242
社区成员




var result = q.GroupBy(g => g.CREATE_USER).Select(s => new
{
userName = s.Key,
count =s.Select(se=>se.PURCHASE_ITEM.PRODUCT_ID).Distinct().Count(),
quantity = s.Sum(ss => ss.TRANSFER_QUANTITY)
});
count =s.Select(se=>se.PURCHASE_ITEM.PRODUCT_ID).Distinct().Count(),
if se.PURCHASE_ITEM is null, then you cannot get the PRODUCT_ID.
so can you try this:
count =s.Where(se=>se.PURCHASE_ITEM !=null).Select(se=>se.PURCHASE_ITEM.PRODUCT_ID).Distinct().Count(),