Send regex command to the database

skoub · Post by **skoub** » Tue 01 Feb 2011 19:40

hi!

i would like to use oracle functions like REGEXP_LIKE, REGEXP_SUBSTR, etc, with EF4.

is there a way to define the regex search criteria in EF4 and be executed on the databgase side?

thank you!

alex

AndreyR · Post by **AndreyR** » Wed 02 Feb 2011 17:34

We will investigate the possibility of adding support for these functions in one of the nearest builds. I will post here about the results of our investigation.

skoub · Post by **skoub** » Thu 03 Feb 2011 14:08

thank you very much!

alex

skoub · Post by **skoub** » Tue 15 Mar 2011 13:02

do you have any news for this feature?

alex

AndreyR · Post by **AndreyR** » Tue 15 Mar 2011 14:36

You can influence the priority of this feature at our EF-specific UserVoice.
Vote for other sugestions as well.

Shalex · Post by **Shalex** » Thu 20 Oct 2011 08:55

The following REGEXP Oracle functions for working with regular expressions are supported:
REGEXP_LIKE (2 overloads)
REGEXP_COUNT (3 overloads)
REGEXP_INSTR (5 overloads)
REGEXP_SUBSTR (4 overloads)
REGEXP_REPLACE (5 overloads)

These functions will be available in EntitySQL and LINQ to Entities via static methods of the OracleFunctions class.

We will post here when the corresponding build of dotConnect for Oracle is available for download.

skoub · Post by **skoub** » Thu 20 Oct 2011 12:43

great! that is good news!!
thank you for the work

alex

Shalex · Post by **Shalex** » Fri 11 Nov 2011 15:48

New build of dotConnect for Oracle 6.50.244 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22547 .