如何使用linqkit，如

Question

data Name{"divan","dîvan","divân","dîvân" }

我想在linq中使用像select * from data where Name like % d_v_n %这样的东西。

那么预期的结果将是"divan","dîvan","divân","dîvân"

 //this linqkit code
 var searchPredicate = PredicateBuilder.False<ViewModelListManuscript>();    
 searchPredicate = searchPredicate.Or(m =>  m.TRTitle.ToLower().Contains("d_v_n"));    
 query = query.AsExpandable().Where(searchPredicate);

结果为空

Answer 1

我认为，您可以这样使用SqlMethods.Like(matchExpression,pattern)：

 var results = from dl in DataList
               where SqlMethods.Like(dl.Name,"%d_v_n%")
               select dl;