The TextSearchQueryBuilder type exposes the following members.

Methods

  NameDescription
BuildDynamicSearchQuery
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 ...)
CreateSpParamName
Helper function for creating a stored procedure parameter name from a keyword's unique index in the TextSearchParameters object where the keyword is stored.
EncodeSQLWildcards
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Finalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
ListArrayJoinOverloaded.
MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
ToString
Returns a String that represents the current Object.
(Inherited from Object.)

See Also