Linq Query Where () SQL% equivalent

Question

We can use the .Contains(string) method in a LINQ expression that sounds like "% search text%", the method .StartsWith(string) that sounds like a "search text%" and the .EndsWith(string) method that sounds like " %% search text '.

But I need something that sounds “% search% text%”, which finds all the content containing “search” and “text” but not sequential.

Example: I have these entries:

search text

text search

search text

In SQL, a query with LIKE '%search%text%' yields:

search my text

search for text

But it does not bring 'seek the text' .

Any ideas?

Answer 1

You can use one of the helper methods:

 var result = from o in ctx.table where SqlMethods.Like(o.column, "%search%text%") select o.column; 

Answer 2

you can use something like this:

 var rx = new Regex("search.*text", RegexOptions.IgnoreCase); List<string> lists=new List<string>(){"search text","search this text","search my book"}; var result = lists.Where(x => rx.IsMatch(x)); 

If you get input in the form of "search% text", you can simply replace the string "%" with ". *" And use Reg ex as the template.