Devart Forums

Posted: **Tue 28 Jul 2015 11:49**

We are trying to utilize EntityFramework with dotConnect for Oracle, we have a blob column which has text index on it. There is a class named OracleTextFunctions for oracle text functions but all its methods supports string property name. You can use

Code: Select all

context.Where(t=>OracleTextFunctions.Contains(t.IndexedColumn,"Some text") > 0 )

on a string property. But Blob columns represented with Byte[] property. So you cant use that function because it has no override support for Byte[] parameter.
and if you use like :

Code: Select all

context.Where(t=>OracleTextFunctions.Contains("IndexedColumn","Some text") > 0 )

it is converted to a sql query like :

Code: Select all

.....
WHERE CONTAINS('IndexedColumn','Some text')

which has single quoted column name and results with ORA-20000 DRG-10599 "column is not indexed" error.
Is there a workaround for this except raw sql query?

Posted: **Wed 29 Jul 2015 12:41**

Thank you for the report on this. We have reproduced this issue. We will investigate it more clearly and inform you about the results as soon as possible.

Posted: **Fri 21 Aug 2015 06:06**

The overloads for Contains and Matches methods are added to the OracleTextFunctions class for using full-text search with the binary columns.
New build of dotConnect for Oracle 8.5.478 is available for download!
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://forums.devart.com/viewtopic.php?f=1&t=32324.

Posted: **Wed 26 Aug 2015 10:24**

Thank you, Much Appreciated.

Devart Forums

Using OracleTextFunctions on a BLOB column

Using OracleTextFunctions on a BLOB column

Re: Using OracleTextFunctions on a BLOB column

Re: Using OracleTextFunctions on a BLOB column

Re: Using OracleTextFunctions on a BLOB column