SqlQuery.FullTextSearchJoin method

Creates the required join for full text search in MSSQL.

public SqlQuery FullTextSearchJoin(string searchTable, string searchFields, string searchQuery, 
    string searchTableAlias, string searchTableKey, string containsAlias)

parameter	description
searchTable	Table name containing the fields to be searched (required).
searchFields	Fields to be searched (required).
searchQuery	Searched word or phrase (required). Words must be separated by comma.
searchTableAlias	Alias assigned to the table to be searched in the FROM part of the query (required, e.g. T0).
searchTableKey	Key (ID) field of the table to be searched (required).
containsAlias	Alias to be assigned to the joined contains table (required, e.g. CT).

Return Value

The SqlSelect object itself.

Exceptions

exception	condition
ArgumentNullException	Any of the parameters is null or empty.

See Also

• class SqlQuery