在Asp.NET C# MVC中展示多个表的查询结果,可以通过以下步骤实现:
public class CustomerOrderViewModel
{
public Customer Customer { get; set; }
public List Orders { get; set; }
}
public ActionResult Index()
{
List viewModelList = new List();
using (var context = new ApplicationDbContext())
{
var customers = context.Customers.ToList();
foreach (var customer in customers)
{
var orders = context.Orders.Where(o => o.CustomerId == customer.Id).ToList();
var viewModel = new CustomerOrderViewModel
{
Customer = customer,
Orders = orders
};
viewModelList.Add(viewModel);
}
}
return View(viewModelList);
}
@model List
@foreach (var viewModel in Model)
{
@viewModel.Customer.Name
Order ID
Order Date
Order Total
@foreach (var order in viewModel.Orders)
{
@order.Id
@order.Date
@order.Total
}
}
通过以上步骤,在Asp.NET C# MVC中可以展示多个表的查询结果。每个顾客的订单信息将以表格的形式显示在视图中。