The TextSearchQueryBuilder type exposes the following members.


Create a dynamic SQL query that has the following format: If there are one or more mandatory words (+ prefix) in the query: SELECT fkPageID, sum(k1.Rank + k2.Rank + ...) as Rank FROM tblPage p INNER JOIN usrPageKeywordViewWithRanks k1 ON k1.pkid=pkid AND k1.Keyword LIKE @Keyword1 INNER JOIN usrPageKeywordViewWithRanks k2 ON k2.pkid=pkid AND k2.Keyword LIKE @Keyword2 ... more joins GROUP BY pkid ORDER BY Rank DESC If there are no mandatory words, but one or more optional words (no +/- prefix): SELECT fkPageID, sum(Rank) as Rank FROM usrPageKeywordViewWithRanks p WHERE (Keyword LIKE @Keyword1+'%' OR Keyword LIKE @Keyword2+'%' OR ...) If there are one or more exclude words (- prefix), add the following to the WHERE clause: AND ("AND" only inserted if there are previous WHERE statements) fkPageID NOT IN (SELECT * FROM usrPageKeywordView p WHERE Keyword LIKE @Keyword3+'%' OR Keyword LIKE @Keyword4+'%' OR ...)
Helper function for creating a stored procedure parameter name from a keyword's unique index in the TextSearchParameters object where the keyword is stored.
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Serves as a hash function for a particular type.
(Inherited from Object.)
Gets the Type of the current instance.
(Inherited from Object.)
Creates a shallow copy of the current Object.
(Inherited from Object.)
Returns a String that represents the current Object.
(Inherited from Object.)

See Also