Page 1 of 1

Send regex command to the database

Posted: Tue 01 Feb 2011 19:40
by skoub
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

Posted: Wed 02 Feb 2011 17:34
by AndreyR
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.

Posted: Thu 03 Feb 2011 14:08
by skoub
thank you very much!

alex

Posted: Tue 15 Mar 2011 13:02
by skoub
do you have any news for this feature?

alex

Posted: Tue 15 Mar 2011 14:36
by AndreyR
You can influence the priority of this feature at our EF-specific UserVoice.
Vote for other sugestions as well.

Posted: Thu 20 Oct 2011 08:55
by Shalex
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.

Posted: Thu 20 Oct 2011 12:43
by skoub
great! that is good news!!
thank you for the work

alex

Posted: Fri 11 Nov 2011 15:48
by Shalex
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 .