public IWhere Contains(IFullTextSearchCondition searchcondition, string language, params string[] columnlist)
{
if (!string.IsNullOrEmpty(language))
{
this.sql.AppendFormat(" CONTAINS({0},{1},LANGUAGE N'{2}')", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchcondition.ToString(), language);
}
else
{
this.sql.AppendFormat(" CONTAINS({0},{1})", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchcondition.ToString());
}
return this;
}
public IFrom ContainsTable(string tableName, IFullTextSearchCondition searchcondition, string language, int top_n_byrank, params string[] columnList)
{
this.sql.AppendFormat(" CONTAINSTABLE({0},{1},'{2}', LANGUAGE N'{3}',{4})", tableName, Utility.GetListAsString <string>(columnList.ToList(), ","), searchcondition.ToString(), language, top_n_byrank);
return(this);
}
public IFrom ContainsTable(string tableName, IFullTextSearchCondition searchcondition, params string[] columnList)
{
this.sql.AppendFormat(" CONTAINSTABLE({0},{1},{2})", tableName, Utility.GetListAsString <string>(columnList.ToList(), ","), searchcondition.ToString());
return(this);
}
public string Contains(IFullTextSearchCondition searchcondition, string language, params string[] columnlist)
{
return(string.Format(" CONTAINS({0},{1},LANGUAGE N'{2}')", Utility.GetListAsString <string>(columnlist.ToList(), ","), searchcondition.ToString(), language));
}
public IWhere FreeText(IFullTextSearchCondition searchterm, params string[] columnlist)
{
this.sql.AppendFormat(" FREETEXT({0},'{1}')", Utility.GetListAsString <string>(columnlist.ToList(), ","), searchterm.ToString());
return(this);
}
public IWhere Contains(IFullTextSearchCondition searchcondition, string language, params string[] columnlist)
{
if (!string.IsNullOrEmpty(language))
{
this.sql.AppendFormat(" CONTAINS({0},{1},LANGUAGE N'{2}')", Utility.GetListAsString <string>(columnlist.ToList(), ","), searchcondition.ToString(), language);
}
else
{
this.sql.AppendFormat(" CONTAINS({0},{1})", Utility.GetListAsString <string>(columnlist.ToList(), ","), searchcondition.ToString());
}
return(this);
}
public IFrom ContainsTable(string tableName, IFullTextSearchCondition searchcondition, string language, int top_n_byrank, params string[] columnList)
{
this.sql.AppendFormat(" CONTAINSTABLE({0},{1},'{2}', LANGUAGE N'{3}',{4})", tableName, Utility.GetListAsString<string>(columnList.ToList(), ","), searchcondition.ToString(), language, top_n_byrank);
return this;
}
public IFrom ContainsTable(string tableName, IFullTextSearchCondition searchcondition, params string[] columnList)
{
this.sql.AppendFormat(" CONTAINSTABLE({0},{1},{2})", tableName, Utility.GetListAsString<string>(columnList.ToList(), ","), searchcondition.ToString());
return this;
}
public string Contains(IFullTextSearchCondition searchcondition, string language, params string[] columnlist)
{
return string.Format(" CONTAINS({0},{1},LANGUAGE N'{2}')", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchcondition.ToString(), language);
}
public IWhere FreeText(IFullTextSearchCondition searchterm, params string[] columnlist)
{
this.sql.AppendFormat(" FREETEXT({0},'{1}')", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchterm.ToString());
return this;
}
