Send regex command to the database

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
skoub
Posts: 32
Joined: Fri 21 May 2010 15:47

Send regex command to the database

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

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

Post by skoub » Thu 03 Feb 2011 14:08

thank you very much!

alex

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

Post by skoub » Tue 15 Mar 2011 13:02

do you have any news for this feature?

alex

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

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

Post by skoub » Thu 20 Oct 2011 12:43

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

alex

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

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 .

Post Reply