Skip to content

Translating LIKE ANY #422

@austindrenski

Description

@austindrenski

Does EF Core/Npgsql have a way to translate a LIKE ANY statement?

For example, translating from this:

IQueryable<string> source; // => "cat"
string[] items = new string[] { "a", "b", "c" };

source.Where(x => items.Any(x.StartsWith));

to this:

WHERE 'cat' LIKE ANY('{a%,b%,c%}');

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions