Creates a new WhereClause

Parameters

relationship

Relationship between all the terms and sub clauses of this clause

Example

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

See Also

WhereClause Class | Reeb.SqlOM Namespace

---