c#实体框架-查询2个链接列

using System;
using System.Linq;

// 创建实体类
public class Order
{
    public int OrderId { get; set; }
    public string OrderNumber { get; set; }
    public int CustomerId { 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("连接字符串");
    }
}

// 查询两个链接列
public class Program
{
    static void Main(string[] args)
    {
        using (var context = new MyDbContext())
        {
            var query = from order in context.Orders
                        join customer in context.Customers on order.CustomerId equals customer.CustomerId
                        select new { order.OrderNumber, customer.CustomerName };

            foreach (var result in query)
            {
                Console.WriteLine($"订单号：{result.OrderNumber}，客户名：{result.CustomerName}");
            }
        }
    }
}