Entity Framework6搜索外键表

// 定义实体类
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 ICollection<Order> Orders { get; set; } // 导航属性
}

// 配置关系
public class MyDbContext : DbContext
{
    public DbSet<Order> Orders { get; set; }
    public DbSet<Customer> Customers { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Order>()
            .HasRequired(o => o.Customer)
            .WithMany(c => c.Orders)
            .HasForeignKey(o => o.CustomerId);
    }
}

// 查询外键表
using (var context = new MyDbContext())
{
    var orders = context.Orders.Include(o => o.Customer).ToList();
    foreach (var order in orders)
    {
        Console.WriteLine($"Order: {order.OrderNumber}, Customer: {order.Customer.CustomerName}");
    }
}