Query: SQL LIKE statement (wildcards) using LINQ

[axelheer]

In the "old" Entity Framework it was possible to use SqlFunctions in order to create something like an ordinary LIKE statement.

... where SqlFunctions.PatIndex("%na_f%", x.Name) > 0...

While in the "new" Entity Framework there seems to be no replacement for SqlFunctions. That approach was a workaround anyway, but some way to use a simple LIKE statement would be very useful. If not essential.

[divega]

Related to #2850.

[smitpatel]

@anpete - Is this same as in-memory like we have?

[axelheer]

Oh, we have EF.Functions.Like now. 🤘

[irg1008]

How can we use the patindex function now? Or could I get the index in which like or match pattern happens?

[roji]

@irg1008 take a look at the comment just above.

[irg1008]

Yeah but Like does not return the index and used inside where, I need to know the index to get a substring of a column value

[roji]

Thanks, I misread your comment. EF Core doesn't current have a translation for SQL Server PATINDEX, I opened #33702 to track that. In the meanwhile, if you need this, you should be able to use user-defined function mapping to map a .NET method stub of your own to PATINDEX.