Answer by jfar for LINQ to Entities Searching text properties for multiple keywords
Original Question/Answer on StackOverflow.com
Looks like Linq to Entities doesn’t support contains:
http://msdn.microsoft.com/en-us/library/bb738638.aspx
I’d roll my own query for this one. Your probably going to want full control over the text search queries if you find out these types of searches become performance issues.