如何根据一对多关系中的知情枚举列表获取记录列表- EF Core

public class Order
{
    public int OrderId { get; set; }
    public string OrderNumber { get; set; }
    public List<Product> Products { get; set; }
}

public class Product
{
    public int ProductId { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
    public int OrderId { get; set; }
    public Order Order { get; set; }
}

using Microsoft.EntityFrameworkCore;
using System.Linq;

public class MyDbContext : DbContext
{
    public DbSet<Order> Orders { get; set; }
    public DbSet<Product> Products { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionString");
    }
}

public class MyService
{
    private readonly MyDbContext _dbContext;

    public MyService(MyDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public List<Order> GetOrdersByEnumList(List<EnumType> enumList)
    {
        var orders = _dbContext.Orders
            .Include(o => o.Products) // 加载产品列表
            .Where(o => enumList.Contains(o.EnumProperty)) // 根据知情枚举列表筛选订单
            .ToList();

        return orders;
    }
}