I want to build a dlinq query that checks to see if a title has any number of items in it. I know you can do .Contains() with a list, but I need to check if the title contains any of the items, not if the items contain part of the title. For example: I have three items in the list "bacon, chicken, pork." I need the title of "chicken house" to match.
var results = (from l in db.Sites
where list.Contains(l.site_title) select l.ToBusiness(l.SiteReviews)).ToList();
If I try the first 2 answers, I get an error "Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator."
The third solution gives me
Method 'System.Object DynamicInvoke(System.Object[])' has no supported translation to SQL."