I have a local collection of recordId's (integers).

I need to retrieve records that have every one of their child records' ids in that local collection.

Here is my query:

public List<int> OwnerIds { get; private set; }
...
filteredPatches = from p in filteredPatches
                  where OwnerIds.All(o => p.PatchesOwners.Select(x => x.OwnerId).Contains(o))
                  select p;

I am getting this error:

Local sequence cannot be used in Linq to SQL implementation of query operators except the Contains() operator.

I get that .All() isn't supported by Linq to SQL, but is there a way to do what I am trying to do?