public WhereClause(WhereClauseRelationship relationship) { this.relationship = WhereClauseRelationship.And; this.whereTerms = new WhereTermCollection(); this.clauses = new WhereClauseCollection(); this.relationship = relationship; }
/// <summary> /// Renders a relationship operator /// </summary> /// <param name="builder"></param> /// <param name="relationship"></param> protected virtual void RelationshipOperator(StringBuilder builder, WhereClauseRelationship relationship) { builder.AppendFormat(" {0} ", relationship.ToString().ToLower()); }
/// <summary> /// Creates a new WhereClause /// </summary> /// <param name="relationship">Relationship between all the terms and sub clauses of this clause</param> /// <example> /// <code> /// SelectQuery query = new SelectQuery(); /// ... /// query.WherePhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field("name", tCustomers), SqlExpression.String("John"), CompareOperator.Equal)); /// WhereClause group = new WhereClause(WhereClauseRelationship.Or); /// group.Terms.Add(WhereTerm.CreateBetween(SqlExpression.Field("price", tProducts), SqlExpression.Number(1), SqlExpression.Number(10))); /// group.Terms.Add(WhereTerm.CreateIn(SqlExpression.Field("name", tProducts), new string[] {"Nail", "Hamer", "Skrewdriver"})); /// query.WherePhrase.SubClauses.Add(group); /// </code> /// </example> public WhereClause(WhereClauseRelationship relationship) { this.relationship = relationship; }
internal WhereClause() { this.relationship = WhereClauseRelationship.And; this.whereTerms = new WhereTermCollection(); this.clauses = new WhereClauseCollection(); }