我有兩個清單。StateNotes - State, CropYear, ..Other properties 定價 - State, CropYear, ..Other properties
我想在Pricings表中選擇 StateNotes 中不存在的每條記錄的State和CropYear 。
例子 ：
狀態說明
{State - Washington, CropYear - 2021 },
{State - Alabama, CropYear - 2022 },
{State - Nevada, CropYear - 2022 }
定價
{State - Washington, CropYear - 2021 },
{State - Alabama, CropYear - 2022 },
{State - Nevada, CropYear - 2021 } *<- this would be selected because there is no combination of Nevada-2021 in StateNotes*
我嘗試了什么：
var stateNotes = repository.AsQueryable<StateNotes>().ToList();
var newStates = pricings.Select(x => new { x.State, x.CropYear }).Except(stateNotes.Select(x => new { x.State, x.CropYear })).ToList();
uj5u.com熱心網友回復：
這應該作業
var newStates = pricings.Where(x => !stateNotes.Any(p => p.State == x.State && p.CropYear == x.CropYear)).ToList();
使用該功能，您可以選擇定價和 stateNotes 之間的差異
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/480456.html
上一篇：如何獲取JS物件并將其傳回？