How to Translate Postgres query to Entity Framework Where Clause

Question

How can I translate the following Postgresql query to the Entity Framework Core Where clause?

select title from some_table where title ~ '[^[:ascii:]]';

Guru Stron · Accepted Answer · 2022-05-08 06:47:55Z

2

~ is an operator for pattern matching using regular expressions. Npgsql EF Core provider automatically translates .NET's Regex.IsMatch so you can just try using it:

context.SomeTable
    .Where(t => Regex.IsMatch(t.Title, "[^[:ascii:]]"))
    ...

edited May 8, 2022 at 6:47

answered May 7, 2022 at 21:29

Guru Stron

150k11 gold badges186 silver badges231 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Translate Postgres query to Entity Framework Where Clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related