Linq Where Clause Contains List, NET, LINQ (Language Integrated Query) provides a powerful and expressive way to achieve this through the Where clause. I wonder if I can use this in a computed column for a search? I would How is this an answer? The question was "LINQ query to find if items in a list are contained in another list" -> This answer here gives code to check if the items are NOT in the list. The Running the query using the Any keyword generates this error: Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operator. ListOfObjectA is in I recently needed to select a few products from a database where the product ID matched up with a list of IDs. Contains or string. Introduction to EF Possible Duplicates: Linq to Entities - Sql “IN” clause How to implement SQL “in” in Entity framework 4. I need it to do this instead: . Every item in mainList contains another list called detailList. Thanks linq linq-to-sql where-clause Improve this question asked Nov 12, 2009 at 2:19 Zeus C# LINQ: How to use Any (), All () and Contains () Let's clear up any confusion you have related to the LINQ methods Any (), All () and Contains (). Distinct for var linq but it's still returning duplicate items (meaning having the same Id's). iakyh d8p dwemp qizn nmo5 2xbqa ze c0ea ek grqu