Send regex command to the database

Send regex command to the database

Postby 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
skoub
 
Posts: 32
Joined: Fri 21 May 2010 15:47

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby skoub » Thu 03 Feb 2011 14:08

thank you very much!

alex
skoub
 
Posts: 32
Joined: Fri 21 May 2010 15:47

Postby skoub » Tue 15 Mar 2011 13:02

do you have any news for this feature?

alex
skoub
 
Posts: 32
Joined: Fri 21 May 2010 15:47

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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.
Shalex
Devart Team
 
Posts: 7612
Joined: Thu 14 Aug 2008 12:44

Postby skoub » Thu 20 Oct 2011 12:43

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

alex
skoub
 
Posts: 32
Joined: Fri 21 May 2010 15:47

Postby 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 .
Shalex
Devart Team
 
Posts: 7612
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle