Implementing search on an ASP.NET MVC website

Question

I've created a content-managed website using ASP.NET MVC. All content is stored in the 'Content' table in a SQL Server database, with the text itself stored in a column of datatype 'XML'.

I want to add a search feature to the site that will search all the XML content and return a list of results, each of which links to the content item.

Any ideas on which technology would be most appropriate?

Should I be using SQL Server full-text indexing, or something else such as DotLucene?

Answer 1

Lucene.net will be a better alternative for you. You can do lot of advanced search through lucene.

Docs @ http://incubator.apache.org/lucene.net/docs/2.1/