How to use linqkit like

Question

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

I want to something like select * from data where Name like % d_v_n % in linq

then the expected result would be "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);

empty result

Answer 1

I think, you can use SqlMethods.Like(matchExpression,pattern) like this:

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