Text Indexing Support - CONTAINS, CTXCAT
I would like to see the CONTAINS and CTXCAT
funtions in the OracleFunctions class. For example:
var result = from x in ents.MyTable
where OracleFunctions.Contains(ctxtextcol, 'test WITHIN TITLE OR test WITHIN NAME') > 0
select x;
This would pretty much remove any requirements I have for writing plain old SQL.
-
Yevhen Shch commented
"Using PostgreSQL Full-Text Search in Entity Framework" article http://blogs.devart.com/dotconnect/using-postgresql-full-text-search-in-entity-framework.html
-
Yevhen Shch commented
"Using MySQL Full-Text Search in Entity Framework" article http://blogs.devart.com/dotconnect/using-mysql-full-text-search-in-entity-framework.html
"Using SQLite Full-Text Search in Entity Framework" article http://blogs.devart.com/dotconnect/using-sqlite-full-text-search-in-entity-framework.html
-
Yevhen Shch commented
The Oracle Text functionality is supported in the latest version of dotConnect for Oracle. For more information, please take a look at "Using Oracle Full-Text Search in Entity Framework" article http://blogs.devart.com/dotconnect/using-oracle-full-text-search-in-entity-framework.html