Implementing Search on the ASP.NET MVC Web Site

Question

I created a content driven website using ASP.NET MVC. All content is stored in the "Content" table in the SQL Server database, and the text itself is stored in the "XML" data type column.

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

Any ideas on which technology would be most suitable?

Should I use SQL Server full-text indexing or something else like DotLucene?

Answer 1

Lucene.net . lucene.

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