Search code examples
sql-server-2008full-text-searchentity-framework-4

Running SQL Server full-text search statements from Entity Framework

Essentially, it's a rehash of this question for Entity Framework 4. How do you do full text search (FTS) with Linq to ADO.NET entity framework?

At this time we are using SqlDataReader where we submit a query with ... WHERE FREETEXT(description, "value). However, as we are moving to EF4, I would prefer to run this query through EF as everything else.

I guess, broader question, is it possible to "pass-through" a SQL so that EF doesn't complain about SQL Server-specific constructs, like freetext()?

Solution

  • If anybody is curious, the answer is to use ExecuteStoreQuery.