Linq查询，其中相关实体包含数组中的值

我有一个名为JobReport的模型，它看起来像这样(简化)

I have a Model called JobReport which looks like this (simplified)

public class JobReport
{
    public JobReport()   
    {
        WorkOrders = new List<WorkOrder>();
    }
    public int JobID { get; set; }
    public List<WorkOrder> WorkOrders{ get; set; }
}

public class WorkOrder
{
    public WorkOrder()   
    {
        Total = 0;
    }
    public string Trade { get; set; }
    public int WorkOrderID { get; set; }
    public decimal? Total { get; set; }
}

我想运行一个Linq查询，该查询可以让我获得所有具有工作订单的工作的订单，而这些工作订单的交易位于传递的数组中.

I'd like to run a Linq query which gets me all the Jobs that have WorkOrders that have a trade which is in a passed array.

var trades = new string[] { }

我尝试了以下类似的操作，但当我实际上需要基础工作时，它试图为我提供工作单列表.

I've tried something like the following which doesn't work, as it tries to get me a list of workorders, when I actually need the underlying jobs.

问题似乎是因为我在致电Select

The problem appears to be because I'm calling Select

var jobsDB = db.Jobs.Include(x=>x.WorkOrders).ToList();

var jobs = (from p in jobsDB
                    select new JobReport()
     {
        JobID = p.JobID,
        WorkOrders = p.WorkOrders.ToList()
     }


jobs = jobs
    .Select(x => x.WorkOrders
    .Where(y => trades.Contains(y.Trade)));