在c#中使用.Include根据条件选择值

using System.Data.Entity;

// 定义实体类
public class Order
{
    public int OrderId { get; set; }
    public string OrderName { 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; }
}

// 创建DbContext类
public class MyDbContext : DbContext
{
    public DbSet<Order> Orders { get; set; }
    public DbSet<Customer> Customers { get; set; }
}

// 使用.Include根据条件选择值
using (var context = new MyDbContext())
{
    var orders = context.Orders
        .Include(o => o.Customer) // 加载Order实体的Customer导航属性
        .Where(o => o.OrderName.Contains("keyword")) // 根据条件选择需要加载的导航属性的值
        .ToList();

    foreach (var order in orders)
    {
        Console.WriteLine($"Order Name: {order.OrderName}, Customer Name: {order.Customer.CustomerName}");
    }
}