Multi-facet search using SQL Server Full Text Search in ASP.NET

Posted on 2012-08-15
Medium Priority
Last Modified: 2012-11-09
I have a basic implementation of using multi-facet searching in a small application I created. Similar to the one this guy has: http://www.isurinder.com/blog/post/2011/01/14/At-Last!-Created-My-Own-eBay-Style-Search-Using-Solrnet.aspx.

I am using SolrNet to create my search facet's. However, SolrNet uses Tomcat Apache as its backbone to do the indexing. Unfortunately, due to hosting restrictions, I cannot install Apache on my clients server.

Is there any .NET alternatives to carry out searching in a similar manner using just .NET and SQL Server?

I have been looking up SQL Server Full Text Indexing, but I don't know how I would use this for my situation.
Question by:R1ND3R
  • 2

Expert Comment

ID: 38299166
Grab some parameters from the user and create a SQL query using a StringBuilder object.  Then, use SQL controls to get the data you want.  This is just one option.


Ryan F

Author Comment

ID: 38309975
Thanks for the response. But is there a better approach then using a StringBuilder to build an SQL query?

Plus, how would you then determine and display how many records are left in another facet?

Accepted Solution

Friman001 earned 1500 total points
ID: 38310573
Edit:  Sorry, I do not think I am answering the questions right.  If I had to give a lead, I would say go after Stored Procedures in MS SQL, if that is what is being used.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question