我在表關系中按表Iscinstances行名稱排序資料時遇到問題， Iscinstances表是LinkUsersToIscinstances表中的JOIN，下面是我對表關系的查詢。
問題是OrderBy a.LinkUsersToIscinstances.Iscinstances.Name是一個錯誤，如何修復訂單查詢？
var customer = await _context.Users
.Where(c => c.UserId == UserId && c.LastActivityDate > date && c.IsApproved == num)
.Include(c => c.Profile)
.Include(a => a.LinkUsersToIscinstances).ThenInclude(b => b.Iscinstances)
.OrderBy(a => a.LinkUsersToIscinstances.Iscinstances.Name).ThenBy(c => c.LastName).ThenBy(c => c.FirstName)
.ToListAsync();
我正在嘗試按表關系中的表行名稱對資料進行排序，我想通過表Iscinstances Name、表 Users LastName、表 Users FirstName獲取查詢以對它們進行排序
這是我的 classis 表關系
UserProfile
public virtual ICollection<LinkUsersToIscinstance> LinkUsersToIscinstances { get; set; }
public virtual ICollection<User> Users { get; set; }
鏈接用戶到實體
public virtual UserProfile Profile { get; set; }
public virtual Iscinstance Iscinstances { get; set; }
public virtual User Users { get; set; }
實體
public virtual ICollection<LinkUsersToIscinstance> LinkUsersToIscinstances { get; set; }
用戶
public virtual UserProfile Profile { get; set; }
public virtual ICollection<LinkUsersToIscinstance> LinkUsersToIscinstances { get; set; }
uj5u.com熱心網友回復：
嘗試以下查詢。
var customer = await _context.Users
.Where(c => c.UserId == UserId && c.LastActivityDate > date && c.IsApproved == num)
.Include(c => c.Profile)
.Include(a => a.LinkUsersToIscinstances.OrderBy(x => x.Iscinstances.Name)).ThenInclude(b => b.Iscinstances)
.OrderBy(c => c.LastName).ThenBy(c => c.FirstName)
.ToListAsync();
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/457288.html
上一篇：為什么腳本和樣式不在ASP.NetWebforms（不是MVC）中呈現
下一篇：在SpringAuthorizationServer(0.2.3 )中支持并發全堆疊MVC(session)認證以及無狀態JWT認證