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;
}
/// <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();
}
