"Select NOT IN" clause in Linq to Entities

Posted by lnetanel on Stack Overflow See other posts from Stack Overflow or by lnetanel
Published on 2010-04-26T13:40:13Z Indexed on 2010/04/26 13:43 UTC
Read the original article Hit count: 390

Filed under:

Hi,
Is there a way to use the "NOT IN (select XXX...)" clause in Linq to Entities?
All the questions I found were regarding a list of objects (IN (1,2,3)) but I want to generate a query with the following syntax:
"select * from table1 where field1 not in(select subfield from subtable)"

Be aware that this is Linq to Entities and not Linq to Sql...

Is it possible?

Thanks!

© Stack Overflow or respective owner

Related posts about linq-to-entities