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-throu开发者_如何学Gogh" a SQL so that EF doesn't complain about SQL Server-specific constructs, like freetext()?
If anybody is curious, the answer is to use ExecuteStoreQuery.
精彩评论