Linq Where list Contains item in another list

Question

Given the following Structure

public class WorkOrderItem 
{
    [Key] 
    public long WorkOrderItemId { get; set; }
    public virtual ICollection<Job> Jobs { get; set; }      
}

public class Job 
{
    [Key]
    public long JobId { get; set; }
    public long? WorkOrderItemId { get; set; }
    public virtual Item Item { get; set; }
    public virtual Element ResultElement { get; set; }
}

How would i get a list of Items where the item had a job that the ResultElementid was in a List<long>()?

Possible duplicate of http://stackoverflow.com/questions/10667675/linq-where-list-contains-any-in-list. — Patrick Hofman, Oct 01 '14 at 14:12
You have forgotten to add the class `Element`, i assume it has an `Id` property. — Tim Schmelter, Oct 01 '14 at 14:13

Tim Schmelter · Accepted Answer · 2014-10-01T14:15:00.253

10

You can use Any + Contains:

var query = workOrderItems
    .Where(item => item.Jobs.Any(j => longList.Contains(j.ResultElement.Id)));

( presuming that the class Element has an Id property since you've stated ResultElementid )

edited Oct 01 '14 at 14:15

answered Oct 01 '14 at 14:12

Tim Schmelter

450,073
74
686
939

I always forget some vital Linq method, in this case it was ANy(). Cheers. – MrBliz Oct 01 '14 at 14:17

Linq Where list Contains item in another list

1 Answers1