How to do a LIKE query with linq? [duplicate]

Question

How can i perform an LIKE query within Linq?

I have the following query i would like to execute.

var results = from c in db.costumers               where c.FullName LIKE "%"+FirstName+"%,"+LastName               select c; 

Answer 1

You could use SqlMethods.Like(matchExpression,pattern)

var results = from c in db.costumers               where SqlMethods.Like(c.FullName, "%"+FirstName+"%,"+LastName)               select c; 

The use of this method outside of LINQ to SQL will always throw a NotSupportedException exception.