asp.net-core - ASP.NET CORE LINQ 分组依据

Question

我对 group by 没什么问题，我想实现这个

Nobukti : 001/des/2019
1000
2000
3000
4000

在我的控制器中

var transaction = await (from a in _context.Transaction group a by a.Nobukti into pg
                                 join b in _context.ChartAccount on pg.FirstOrDefault().Kodeakun
                                 equals b.Kodeakun
                                  select new Transaksi
                                  {   
                                      Nobukti = pg.First().Nobukti,
                                      Kodeakun = pg.FirstOrDefault().Kodeakun + b.Namaakun
                                  }).ToListAsync();

在我看来

<table class="table">
@foreach (var item in Model)
{
    <thead>
        <tr>
            <th>
                @Html.DisplayNameFor(model => model.Nobukti)
            </th>
            <td>
                @Html.DisplayFor(modelItem => item.Nobukti)
        </tr>
    </thead>
    <tbody>
        <tr>
        @foreach (var book in item.Nobukti)
            {
            <td>
                @Html.DisplayFor(modelItem => item.Kodeakun)
            </td>
            }
        </tr>
    </tbody>
}
    </table>

谁能帮我？我不知道哪个错，我的控制器或我的观点，抱歉英语

标签： asp.net-coreentity-framework-core