LINQ 模糊搜索

IList<entity> ls = new List<entity>();
ls = (from k in ls
where k.Name.Contains("safdsa") || k.PinSpell.Contains("MJ")
select k).ToList();

 

等同于    like '%safdsa%' or like '%MJ%'