Is it possible to use Full Text Search (FTS) with LINQ?

by

Yes. However you have to create SQL server function first and call that as by default LINQ will use a like.

This blog post which will explain the detail but this is the extract:

To get it working you need to create a table valued function that does
nothing more than a CONTAINSTABLE query based on the keywords you pass
in,

create function udf_sessionSearch
      (@keywords nvarchar(4000))
returns table
as
  return (select [SessionId],[rank]
            from containstable(Session,(description,title),@keywords))

You then add this function to your LINQ 2 SQL model and he presto you
can now write queries like.

    var sessList = from s   in DB.Sessions
                   join fts in DB.udf_sessionSearch(SearchText) 
                   on s.sessionId equals fts.SessionId
                 select s;

More Related Contents:

  1. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  2. How do you get leading wildcard full-text searches to work in SQL Server?
  3. Defining a one-to-one relationship in SQL Server
  4. Full text search does not work if stop word is included even though stop word list is empty
  5. Using NOLOCK Hint in EF4?
  6. SQL Server Full Text Search Escape Characters?
  7. 7645 Null or empty full-text predicate
  8. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  9. Full text catalog/index search for %book%
  10. how to select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  11. SQL server query to output the data shown below
  12. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  13. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  14. How to use a variable for the database name in T-SQL?
  15. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  16. Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
  17. Create a view with ORDER BY clause
  18. Why is 1899-12-30 the zero date in Access / SQL Server instead of 12/31?
  19. Date conversion and culture: Difference between DATE and DATETIME
  20. Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
  21. How to remove accents and all chars a..z in sql-server?
  22. RODBC odbcDriverConnect() Connection Error
  23. How can I do something like: USE @databaseName
  24. Calling an API from SQL Server stored procedure
  25. SSIS Excel Import Forcing Incorrect Column Type
  26. Is there a way to not use square brackets in SQL Server?
  27. Entity-framework code is slow when using Include() many times
  28. How do you set autocommit in an SQL Server session?
  29. Avg of float inconsistency
  30. Milliseconds wrong when converting from XML to SQL Server datetime

Leave a Comment