How to use Oracle Full Text Search in an Entity Framework

July 25, 2012

Oracle has the solutions, but how do you use Oracle full text search in an entity framework? We are not sure what this means, but the info you need can be found in Devart’s article, “Using Oracle Full-Text Search in Entity Framework.”

Devart began with:

“We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the basic Oracle Text functionality in our Devart dotConnect for Oracle ADO.NET Entity Framework provider. For working with Oracle Text specific functions in LINQ to Entities queries, the new OracleTextFunctions class is used, which is located in the Devart.Data.Oracle.Entity.dll assembly.”

It enables working with such Oracle Text functions as:

  • CONTAINS
  • CATSEARCH
  • MATCHES
  • SCORE
  • MATCH_SCORE

Devart presents a very detailed sales pitch for OraDirect, or dotConnect as their calling it now. Whatever name you choose, the gist is the software offers native connectivity to the Oracle database, tools and technology. They also offer a customized set of their own tools to increase Dataset productivity such as Dataset Wizard and Dataset Manager.

If you can decipher their article, than the wisdom of the Oracle is yours. For the most part this article reads like a coder handbook, and I am not a coder. If you happen to speak that very enlightened language, you will probably grasp Devart’s meaning a lot quicker than this gosling. If not, maybe the Oracle will see you some other day.

Jennifer Shockley, July 25, 2012

Sponsored by IKANOW

Comments

2 Responses to “How to use Oracle Full Text Search in an Entity Framework”

  1. Using Oracle Full-Text Search in Entity Framework « Another Word For It on July 25th, 2012 5:05 pm

    [...] first saw this at Beyond Search (As Stephen implies, it is not a resource for casual data [...]

  2. Using MySQL Full-Text Search in Entity Framework « Another Word For It on July 25th, 2012 7:14 pm

    [...] to say why Beyond Search picked up the Oracle post but left the MySQL one [...]