"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: 434

Filed under:

linq-to-entities

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!

Related posts about linq-to-entities

Linq to Entities : using ToLower() on NText fields

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using SQL Server 2005, with a case sensitive database.. In a search function, I need to create a Linq To Entities (L2E) query with a "where" clause that compare several strings with the data in the database with these rules : The comparison is a "Contains" mode, not strict compare : easy as… >>> More
HELP: deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LiNQ to Entities, Include less

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this: var temp = from p in myEntities.ClassA.Include("ClassB") where ... select p; You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case… >>> More
deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LINQ To Entities - Items, ItemCategories & Tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags. I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often. I currently… >>> More

Developer IT

"Select NOT IN" clause in Linq to Entities - Developer IT

"Select NOT IN" clause in Linq to Entities

linq-to-entities

Related posts about linq-to-entities

Linq to Entities : using ToLower() on NText fields

HELP: deploying applications that use LINQ to Entities.

LiNQ to Entities, Include less

deploying applications that use LINQ to Entities.

LINQ To Entities - Items, ItemCategories & Tags

Categories cloud