如何在实体框架表关系 LINQ 方法语法中对数据查询进行排序？

Question

我在表关系中按表 Iscinstances 行 Name 排序数据时遇到问题，Iscinstances 表JOIN LinkUsersToIscinstances 表，下面是我对表关系的查询。

问题是 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，表用户 名字

这是我的分类表关系

UserProfile

    public virtual ICollection<LinkUsersToIscinstance> LinkUsersToIscinstances { get; set; }
    public virtual ICollection<User> Users { get; set; }

LinkUsersToIscinstance

    public virtual UserProfile Profile { get; set; }
    public virtual Iscinstance Iscinstances { get; set; }
    public virtual User Users { get; set; }

Iscinstance

    public virtual ICollection<LinkUsersToIscinstance> LinkUsersToIscinstances { get; set; }

User

    public virtual UserProfile Profile { get; set; }
    public virtual ICollection<LinkUsersToIscinstance> LinkUsersToIscinstances { get; set; }

Answer 1

尝试以下查询。

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();