How to use full-text search with Linq?

Question

SQL Server 2008 provides four functions for full-text search: CONTAINS, CONTAINS, FREETEXT, FREETEXTTABLE

How to use it with Linq?

Answer 1

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

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.

Answer 2

. postoverflow post " (FTS) LINQ?", " Linq to SQL - "

Answer 3

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