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;
Entity "IN" statement
This problem is discussed here:
http://www.devart.com/forums/viewtopic.php?t=13834
http://www.devart.com/forums/viewtopic.php?t=13834