/// <summary> /// Sets the statement WHERE clause in the form of /// <code> /// "WHERE <condition> {[AND | OR] <condition> ...}" /// </code> /// e.g. "a = b OR b = c". The "WHERE " keyword will be ignored. /// </summary> /// <param name="conditions">The statement query without "WHERE"</param> /// <returns>The statement builder, for chaining method calls.</returns> public StatementBuilder Where(String conditions) { PreconditionUtilities.CheckArgumentNotNull(conditions, "conditions"); this.where = RemoveKeyword(conditions, WHERE); return(this); }
/// <summary> /// Sets the statement SELECT clause in the form of "a,b". /// Only necessary for statements being sent to the /// <see cref="PublisherQueryLanguageService"/>. /// The "SELECT " keyword will be ignored. /// </summary> /// <param name="columns"> /// The statement serlect clause without "SELECT". /// </param> /// <returns>The statement builder, for chaining method calls.</returns> public StatementBuilder Select(String columns) { PreconditionUtilities.CheckArgumentNotNull(columns, "columns"); this.select = RemoveKeyword(columns, SELECT); return(this); }
/// <summary> /// Sets the statement FROM clause in the form of "table". /// Only necessary for statements being sent to the /// <see cref="PublisherQueryLanguageService"/>. /// The "FROM " keyword will be ignored. /// </summary> /// <param name="table">The statement from clause without "FROM"</param> /// <returns>The statement builder, for chaining method calls.</returns> public StatementBuilder From(String table) { PreconditionUtilities.CheckArgumentNotNull(table, "table"); this.from = RemoveKeyword(table, FROM); return(this); }
/// <summary> /// Sets the statement ORDER BY clause in the form of /// <code>"ORDER BY <property> [ASC | DESC]"</code> /// e.g. "type ASC, lastModifiedDateTime DESC". /// The "ORDER BY " keyword will be ignored. /// </summary> /// <param name="orderBy">the statement order by without "ORDER BY"</param> /// <returns>The statement builder, for chaining method calls.</returns> public StatementBuilder OrderBy(String orderBy) { PreconditionUtilities.CheckArgumentNotNull(orderBy, "orderBy"); this.orderBy = RemoveKeyword(orderBy, ORDER_BY); return(this); }