2

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?

Improve this question
1
  • If you are here because you have the same problem, don't have illusions. I bountied this question and nobody answer Commented Oct 13, 2021 at 7:25
Related questions
0
Dynamic LINQ API - SQL Convert Function
5
Select clause containing non-EF method calls
1
DynamicQuery: How to select a column with linq query that takes parameters
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.