Using contains with wildcard in Entity Framework Core

Asked Aug 09 '18 at 20:27

Active Aug 11 '18 at 18:44

Viewed 140 times

After reading then question How to do SQL Like % in Linq? I still have doubts when I need to use wildcard inside the string, like this:

%cro%ft%

And get results like:

Microsoft
Microsoft Corporation
Acrobat software

For some reason, a simple contains does not works.

update:

Using .contains(string1) && .contains(string2), give me this sql command:

SELECT s."Nome", s."Id", s."Cpf"
  FROM "Pacientes" AS s
 WHERE ((STRPOS(s."Nome", 'cro') > 0) AND (STRPOS(s."Nome", 'ft') > 0))
   AND (s."ClinicaId" = @__clinicId_0)
 ORDER BY s."Nome"

instead of a clean sql like:

SELECT s."Nome", s."Id", s."Cpf"
  FROM "Pacientes" AS s
 WHERE (s.Nome like '%cro%ft%')
   AND (s."ClinicaId" = @__clinicId_0)
 ORDER BY s."Nome"

My code in production is:

result = result.Where(s => s.Nome.ToLower().Contains(name.ToLower()));

edited Aug 09 '18 at 20:46

asked Aug 09 '18 at 20:27

Beetlejuice

4,292
10
58
84

1

@Chad That post is tagged as [tag:linq-to-sql]; not the same thing as EF. – Kenneth K. Aug 09 '18 at 20:41
Looks like EF Core 2.1 has [a set of extension methods](https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.dbfunctionsextensions.like?view=efcore-2.1#Microsoft_EntityFrameworkCore_DbFunctionsExtensions_Like_Microsoft_EntityFrameworkCore_DbFunctions_System_String_System_String_System_String_) you can use. – Kenneth K. Aug 09 '18 at 20:47
@GertArnold, the user type the wildcard, so I don´t know what he will type. Could be %ab%c%de%... – Beetlejuice Aug 09 '18 at 20:48
@KennethK. This could be helpfull. How to use it ? – Beetlejuice Aug 09 '18 at 20:51
Is my change applied: `result.Where(s => EF.Functions.Like(x.Name,"yourWildcardSQLpattern"));` – Dongdong Aug 09 '18 at 20:51
@Dongdong, works like a charm. – Beetlejuice Aug 09 '18 at 20:56
Duplicate of https://stackoverflow.com/q/1040380/1353267 maybe? – Samveen Aug 10 '18 at 06:15
It looks like a bug. It should work similarly to `string.Contains`. – Serg Dec 24 '19 at 17:22

Using contains with wildcard in Entity Framework Core

update:

0 Answers0