if I got a List(of t) how to filter out item from a linq 2 sql query?

Question

I have a list(of t) and I got a iqueryable(of a)

I want to filter out any item from the iqueryable(of a) where a.id = t.myotherid

I'm not really sure how to write this query, anyone could help me here?

For now I got this

Dim listCie = (From c In db.getListCompany() _
                Where Not rels.Select(Function(a) a.ChildID).Contains(c.ID) _
                  And Not rels.Select(Function(a) a.ParentId).Contains(c.ID) _
                Select c)

question is, should I use .Any or is there any better way?

Answer 1

Dim result = From item In queryable _
             Where Not list.Select(Function(x) x.MyOtherId).Contains(item.Id) _
             Select item

Answer 2

I think that what you want to do can be achieved with a join. You can get some examples here

Answer 3

Dim result = From item In queryable _
             Where Not list.Any(Function(t) t.MyOtherID = item.Id) _
             Select item

An alternative is to use the .Intersect() method.