c# - Razor 页面不显示外部表数据

Question

我有一个带有两个外键及其各自导航属性的模型类。但是，在加载这个模型类时，外部表数据没有显示出来。

以下是类代码：

public class SquadPlayer
{
    public int Id { get; set; }

    public int SquadId { get; set; }

    public int PlayerId { get; set; }

    public Squad Squad { get; set; }

    public Player Player { get; set; }
}

后端.cs代码

public async Task OnGetAsync()
{
    SquadPlayer = await _context.SquadPlayers.ToListAsync();
}

显示 .cshtml 代码

<td>
       @Html.DisplayFor(modelItem => item.Squad.Name)
</td>
<td>
       @Html.DisplayFor(modelItem => item.Player.Name)
</td>

标签： c#entity-frameworkasp.net-coreentity-framework-corerazor-pages

Answer 1

更新此代码：

public async Task OnGetAsync()
{ 
    SquadPlayer = await _context.SquadPlayers.ToListAsync(); 
}

至：

public async Task OnGetAsync()
{ 
    SquadPlayer = await _context.SquadPlayers
                                .Include(x => x.Squad)
                                .Include(x => x.Player).ToListAsync(); 
}