1 回答

TA貢獻(xiàn)1813條經(jīng)驗(yàn) 獲得超2個(gè)贊
解決方案 1:在 IQueryable 上執(zhí)行查詢之前,必須包含相關(guān)表,如下所示:
var userId = HttpContext.Session.GetInt32("user");
User user = _context.Users.Where(u => u.id == userId)
.Include(u => u.Transactions)
.AsNoTracking()
.FirstOrDefault();
解決方案 2:您可以選擇具有該用戶交易列表的用戶,如下所示:
var userId = HttpContext.Session.GetInt32("user");
User user = _context.Users
.AsNoTracking()
.Where(u => u.id == userId)
.Select(u => new User
{
//Select all properties like this :
FirstName = u.FirstName,
LastName = u.LastName,
//... Other properties,
Transactions = u.TransActions.Select(t => new TransationViewModel
{
//Select all properties like this :
//Name = t.Name
}).ToList()
})
.FirstOrDefault();
- 1 回答
- 0 關(guān)注
- 141 瀏覽
添加回答
舉報(bào)