Hi there,
How can I use "ILIKE" in a LINQ query in DotnetConnect for Postgres?
If I try to use Devart.Data.PostgreSQL.Entity.PgSqlFunction.ILIKE, it throws an error "Method 'Boolean ILike(System.String, System.String)' is not supported for execution as SQL."
I can get a result if I use Devart.Data.Linq.SqlMethods.Like, but that is case sensitive, hence the need for "ILike".
Here is the sample code I'm trying to run.
Dim rows = (From client In dc.clients
Where Devart.Data.PostgreSql.Entity.PgSqlFunctions.ILike(client.surname, "%smith%")).ToArray()