使用EntityFramework从2个以上的表中获取数据

using System;
using System.Linq;

// 创建一个继承自DbContext的上下文类
public class MyDbContext : DbContext
{
    public DbSet<Customer> Customers { get; set; }
    public DbSet<Order> Orders { get; set; }
}

// 定义Customer实体类
public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

// 定义Order实体类
public class Order
{
    public int Id { get; set; }
    public int CustomerId { get; set; }
    public string ProductName { get; set; }
}

class Program
{
    static void Main(string[] args)
    {
        using (var context = new MyDbContext())
        {
            // 使用LINQ查询语法从两个表中获取数据
            var query = from c in context.Customers
                        join o in context.Orders on c.Id equals o.CustomerId
                        select new { CustomerName = c.Name, OrderProduct = o.ProductName };

            foreach (var result in query)
            {
                Console.WriteLine($"Customer: {result.CustomerName}, Order: {result.OrderProduct}");
            }
        }
    }
}