Cosmos: Translate regex matching

[sekarcse]

How to use RegexMatch in EF Core Cosmos C#

I want to apply the below in Linq. Here code is in-case sensitive

Cosmos Query
SELECT * FROM c
WHERE RegexMatch (c.Code, "ZWw","i")

[roji]

This isn't currently supported, but you can use raw SQL queries to call the function in SQL yourself.

Cosmos docs for the function

[sekarcse]

Thanks @roji for the quick reply

[Marusyk]

@roji @AndriySvyryd What is your point of view for implementing this feature?

smth like this?

dataSet.Where(x => EF.Functions.RegexMatch(x, "Zxw", "i"));

[roji]

@Marusyk if possible, translating built-in .NET functions is preferred. For example, the PG provider supports regex by translating Regex.IsMatch(stringValue, "^A+") (see docs).

[AndriySvyryd]

Adding to what @roji said you can also translate some of the options, but throw for the ones not supported by Cosmos.

RegexOptions	Modifier
Multiline	m
Singleline	s
IgnoreCase	i
IgnorePatternWhitespace	x

[roji]

Note: we also already translate Regex.IsMatch in SQLite and have tests for it in NorthwindFunctionsQueryTestBase.