区别使用条件Linq(Distinct Using Condition Linq)

 所以我已经花了一些时间用这个linq并且无法提出最佳解决方案。 考虑以下linq 
 
 
 我希望能够根据BaseItemID值选择不同的条目，所以例如每当我有两个Chicken条目时，我想选择第二个条目，因为它取代了第一个条目。 短语的另一种方法是每当条目具有BaseItemID值时，选择此条目并从列表中删除基本条目，因此将返回列表并删除项目1003。 另一种表达条件的方法是仅选择BaseItemID字段中任何行中不存在其ID值的项目。 
 
 如果我可以按名称分组，然后选择具有BaseItemID！= null和Count> 1的项目，那么问题就很容易了，但事实并非如此，而且Name字段不是唯一的，我真的不能依赖于它用于分组。 
 
 谢谢 

So I have been spending sometime with this linq and couldn't come up with an optimal solution. Considering the following linq
 
 
I want to be able to select the distinct entries based on the BaseItemID value, so for example whenever I have two Chicken entries, I want to select the second entry because it superseeds the first entry. Another way to phrase it is whenever an entry have a BaseItemID value, pick this entry and remove the base entry from the list, so the list would be returned with the Item 1003 removed. Yet another way to phrase the condition is to select only the items that doesnot have their ID value existing in any row in the BaseItemID field.
 
The problem would have been easy if I can group by the name for example, and then pick the item with the BaseItemID != null and Count > 1, but thats not the case and the Name field is not unique and i cant really depend on it for the grouping.
 
Thanks

原文：