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

Posted on 2012-08-15
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:!-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
    LVL 4

    Expert Comment

    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

    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?
    LVL 4

    Accepted Solution

    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

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now