Entity "IN" statement

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
BreakFire
Posts: 1
Joined: Fri 09 Jan 2009 08:55

Entity "IN" statement

Post by 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;

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

Post by AndreyR » Fri 09 Jan 2009 14:00


Post Reply