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; }