c# - LIKE query with Entity Framework

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/11786664/like-query-with-entity-framework

Answer 1

Would something like this linq query work for you.. ?

var matches = from m in db.Customers
    where m.Name.Contains(key)      
    select m;

this should also work I edited my answer.

Contains is mapped to LIKE '%@p0%' which is case insensitive