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?