我有一個查詢，我的 ThenInclude Where 需要訪問原始資料集中的資料，例如
var bikes = context.Bikes
.Include(bike => bikes.Models)
.ThenInclude(model => model.Spec.Where(spec=> spec.SpecYear == bike.YearCreated ))
.ToList();
我目前在兩個單獨的查詢中都有這個，但如果我在資料庫上完成這個請求會節省很多時間。
uj5u.com熱心網友回復：
嘗試使用投影而不是Include：
var bikes = context.Bikes
.Select(bike = new Bike
{
Id = bike.Id,
// ... other fields
Models = bike.Models.Select(m => new Model
{
Id = m.Id
// ... other fields
Spec = m.Spec
.Where(spec => spec.SpecYear == bike.YearCreated)
.ToList()
})
})
.ToList();
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/446620.html