I know Linq doesn't have a function that supports FullTextSearch, but my website (which uses Linq to SQL and Linq) needs to make use of FullTextSearch.
I have two options to use FullTextSearch and Linq which are:
Create a stored procedure in SQL server and query the SP via Linq
Create a function in SQL server and use the function within a Linq statement
Does any one have any opinion as to what is better or is it a preference thing?
DaveRook
Member
582 Points
330 Posts
Linq to Sql - FullTextSearch
Feb 20, 2012 02:36 PM|LINK
Hi
I know Linq doesn't have a function that supports FullTextSearch, but my website (which uses Linq to SQL and Linq) needs to make use of FullTextSearch.
I have two options to use FullTextSearch and Linq which are:
Does any one have any opinion as to what is better or is it a preference thing?
Thanks
Dave
DaveRook
Member
582 Points
330 Posts
Re: Linq to Sql - FullTextSearch
Feb 21, 2012 08:40 AM|LINK
And the answer is function! It is difficult to query the results with a stored proceudre in linq (it will create more work for the compiler).