开发者

Running SQL Server full-text search statements from Entity Framework

开发者 https://www.devze.com 2023-01-11 07:17 出处:网络
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?

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消