Using postgresql unaccent function in a dynamic linq query

271 views Asked by At

According to: Query PostgreSQL with Npgsql and Entity Framework using unaccent

I added the NuGet Library and everything works:

var result = _context.Table.Where(h => _context.Unaccent(h.Description) == "GARCÍA");

But I don't know how to combine it with Dynamic Linq library

whereStr = $"{fieldName} == \"{searchString}\"";

I tried some things like:

whereStr = $"unaccent({nameField}) {searchOpeStr} \"{searchString}\"";
whereStr = $"\"public\".\"unaccent\"({nameField}) {searchOpeStr} \"{searchString}\"";
whereStr = $"Context.Unaccent({nameField}) {searchOpeStr} \"{searchString}\"";

But nothing works. Any ideas?

0

There are 0 answers