Entity Framework Core Postgres ILike function

Question

context.Company.Where(i => EF.Functions.ILike(i.Name, "xxx%")).FirstOrDefault()

I just need to use ILike in EF Core. But this function is Postgres specific. If some day the database change to Sql Server. All the code like this need to be updated.

Any ways to avoid this issue?

why cant you use normal linq syntax ?

Arunprasanth K V
– Arunprasanth K V

2019-03-01 09:14:12 +00:00
Commented Mar 1, 2019 at 9:14 — Arunprasanth K V
– Arunprasanth K V, Commented Mar 1, 2019 at 9:14
i need use ILike

amingo
– amingo

2019-03-04 09:01:32 +00:00
Commented Mar 4, 2019 at 9:01 — amingo
– amingo, Commented Mar 4, 2019 at 9:01

DharmaTurtle · Accepted Answer · 2020-05-18 11:39:58Z

3

This seems to be database agnostic:

context.Counties.Where(x => x.Name.ToLower().Contains(keyword.ToLower())).ToList();

From: https://stackoverflow.com/a/56043524

answered May 18, 2020 at 11:39

DharmaTurtle

8,7877 gold badges45 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework Core Postgres ILike function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related