使用linq的mvc5中按外键表分组的表

using System.Linq;
using System.Data.Entity;

public ActionResult GroupByForeignKey()
{
    using (var db = new YourDbContext())
    {
        var groupedOrders = db.Orders.Include(o => o.Customer)
                                     .GroupBy(o => o.Customer)
                                     .ToList();
        
        return View(groupedOrders);
    }
}

@model List<IGrouping<Customer, Order>>

@foreach (var group in Model)
{
    <h3>@group.Key.Name</h3> <!-- 显示客户名称 -->
    
    <table>
        <tr>
            <th>订单号</th>
            <th>订单日期</th>
            <!-- 其他订单相关信息 -->
        </tr>
        
        @foreach (var order in group)
        {
            <tr>
                <td>@order.OrderNumber</td>
                <td>@order.OrderDate</td>
                <!-- 其他订单相关信息 -->
            </tr>
        }
    </table>
}