LINQ: Entity string field contains any of an array of strings

Viewed 56507

I want to get a collection of Product entities where the product.Description property contains any of the words in a string array.

It would look something like this (result would be any product which had the word "mustard OR "pickles" OR "relish" in the Description text):

Dim products As List(Of ProductEntity) = New ProductRepository().AllProducts

Dim search As String() = {"mustard", "pickles", "relish"}

Dim result = From p In products _
     Where p.Description.Contains(search) _
     Select p

Return result.ToList

I already looked at this similar question but couldn't get it to work.

3 Answers
Related