Performing LIKE '%query%' Searches in LINQ
When you need SQL-style LIKE '%keyword%' behavior in LINQ to SQL or Entity Framework, the simplest approach is to use Contains(). It automatically translates to a SQL LIKE query.
When you need SQL-style LIKE '%keyword%' behavior in LINQ to SQL or Entity Framework, the simplest approach is to use Contains(). It automatically translates to a SQL LIKE query.