How to use full-text search with Linq?

Question

There are 4 functions provided in SQL Server 2008 for full-text search: CONTAINS, CONTAINSTABLE, FREETEXT, FREETEXTTABLE

How to use it them with Linq ?

score 2 · Answer 1 · answered Jan 15 '10 at 20:36

You cannot translate a linq query into full-text search functions, there is no direct support for this.

However, there are some workarounds - see http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx for an indirect method of using full-text search.

score 1 · Answer 2 · edited May 23 '17 at 11:48

1

See stackoverflow post "Is it possible to use Full Text Search (FTS) with LINQ?" which provides a link to the blog post "Linq to SQL - Enabling Fulltext Search"

edited May 23 '17 at 11:48

Community

1
1

answered Jan 15 '10 at 22:36

Cory

12,404
7
33
28

score 0 · Answer 3 · answered Jan 15 '10 at 20:36

0

As far as I know, there's no built-in support for those functions in LINQ - you'll need to formulate your T-SQL query and then use the Linq's DataContext.ExecuteQuery() call to send that T-SQL directly to SQL Server.

answered Jan 15 '10 at 20:36

marc_s

732,580
175
1,330
1,459

How to use full-text search with Linq?

3 Answers3