Postgresql with accent-insensitive and case-insensitive pattern matching

08:46 27 Jan 2025

Is there a simpler way to make a AI and CI search with Entity Frameworkd and Postgres than use multipe EF.Functions?

EF.Functions.ILike(
        EF.Functions.Unaccent(u.Name), 
        EF.Functions.Unaccent($"%{value}%")
    )

sql postgresql entity-framework-core collation postgresql-18