如何在ASP.NET MVC中使用实体框架连接两个或多个表？

// 实体类
public class Category
{
    public int CategoryId { get; set; }
    public string Name { get; set; }
    public virtual ICollection<Product> Products { get; set; }
}

public class Product
{
    public int ProductId { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
    public int CategoryId { get; set; }
    public virtual Category Category { get; set; }
}

// 数据库上下文类
public class ApplicationDbContext : DbContext
{
    public DbSet<Category> Categories { get; set; }
    public DbSet<Product> Products { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Product>()
            .HasRequired(p => p.Category)
            .WithMany(c => c.Products)
            .HasForeignKey(p => p.CategoryId);
    }
}

// 控制器
public class HomeController : Controller
{
    private readonly ApplicationDbContext _context;

    public HomeController()
    {
        _context = new ApplicationDbContext();
    }

    public ActionResult Index()
    {
        var categories = _context.Categories.Include(c => c.Products).ToList();
        return View(categories);
    }
}

// 视图
@model List<Category>

<table>
    <thead>
        <tr>
            <th>Category</th>
            <th>Products</th>
        </tr>
    </thead>
    <tbody>
        @foreach (var category in Model)
        {
            <tr>
                <td>@category.Name</td>
                <td>
                    <ul>
                        @foreach (var product in category.Products)
                        {
                            <li>@product.Name - @product.Price</li>
                        }
                    </ul>
                </td>
            </tr>
        }
    </tbody>
</table>