One of the projects I am working on is a search engine. This search engine has 36 parameters that can be set to a search within the form, and results are displayed through a series of scoring mechanisms. For example, if you were searching for a desk with a certain width, it would find the desks closest to the desired width and then sort it.
It would give a "score" to items within a certain distance; 10 for perfect, 8 for within 5 inches, etc. You would add the score given to a tally and then sort the scores descending from the highest overall score.
We are now moving from Classic ASP to ASP.NET MVC2 and want to integrate this as best possible within the database queries using LINQ-to-SQL. My question is how would one go about such a scoring system?
I highly appreciate all answers :) .