Linq to SQL Search Query

Question

Hey, I have a table of news, and I want to allow the user to search in it. Something like this:

News.Where(p => p.Title == user_query);

...that will allow more advanced queries, like Differences Between "Linq to Objects" and "Linq to SQL" queries, etc. Also it should be incase-sensitive.

Any ideas?

Thank you.

Answer 1

From John's answer here:

LINQ to SQL does not support Full Text Search, but you can write a stored procedure and call that. See this blog post for more details.