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 stackoverflow.com/questions/10667675/…. — Patrick Hofman
– Patrick Hofman, Commented Oct 1, 2014 at 14:12
You have forgotten to add the class Element, i assume it has an Id property. — Tim Schmelter
– Tim Schmelter, Commented Oct 1, 2014 at 14:13

Tim Schmelter · Accepted Answer · 2014-10-01 14:15:00Z

11

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 1, 2014 at 14:15

answered Oct 1, 2014 at 14:12

Tim Schmelter

462k79 gold badges718 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MrBliz Over a year ago

I always forget some vital Linq method, in this case it was ANy(). Cheers.

Collectives™ on Stack Overflow

Linq Where list Contains item in another list

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related