C#使用Include连接两个表。数据来自模型

using System;
using System.Linq;
using Microsoft.EntityFrameworkCore;

// 定义模型类
public class Order
{
    public int OrderId { get; set; }
    public string OrderNumber { get; set; }
    public int CustomerId { get; set; }
    public Customer Customer { get; set; }
}

public class Customer
{
    public int CustomerId { get; set; }
    public string CustomerName { get; set; }
}

// 定义数据库上下文类
public class MyDbContext : DbContext
{
    public DbSet<Order> Orders { get; set; }
    public DbSet<Customer> Customers { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("连接字符串");
    }
}

// 使用Include连接两个表
public class Program
{
    static void Main(string[] args)
    {
        using (var context = new MyDbContext())
        {
            var orders = context.Orders.Include(o => o.Customer).ToList();
            foreach (var order in orders)
            {
                Console.WriteLine($"订单号：{order.OrderNumber}，客户名：{order.Customer.CustomerName}");
            }
        }
    }
}