Entity "IN" statement

Entity "IN" statement

Postby BreakFire » Fri 09 Jan 2009 09:11

Hi guys,

I like to use the SQL "IN" statement equivalent in LINQ to Entity syntax. I understand the .Contains extension method is not supported by Microsoft. Can anyone provide me with an alternative ?


This does not work, using dotConnect for Oracle.:?:

List myList = new List(){122334455,155664455,9437646};

var result = from product in Context.Products.Include("Details")
where myList.Contains(product.Id)
select product;
BreakFire
 
Posts: 1
Joined: Fri 09 Jan 2009 08:55

Postby AndreyR » Fri 09 Jan 2009 14:00

AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle