/// <summary> /// Adds an OR condition to the select statement. /// </summary> /// <param name="select">The select statement.</param> /// <param name="column">The column.</param> /// <param name="op">The op.</param> /// <param name="value">The value.</param> /// <returns>The select statement.</returns> public static SelectStatement Or(this SelectStatement select, SourceExpression column, SqlOperator op, object value) { select.Conditions.Add(new Condition(column, op, value) { Relationship = ConditionRelationship.Or }); return(select); }
/// <summary> /// Adds a NOT condition to the select statement. /// </summary> /// <param name="select">The select statement.</param> /// <param name="column">The column.</param> /// <param name="op">The op.</param> /// <param name="value">The value.</param> /// <returns>The select statement.</returns> public static SelectStatement WhereNot(this SelectStatement select, SourceExpression column, SqlOperator op, object value) { select.Conditions.Add(new Condition(column, op, value) { Not = true }); return(select); }
/// <summary> /// Initializes a new instance of the <see cref="BinaryOperation" /> class. /// </summary> /// <param name="left">The expression on the left of the operator.</param> /// <param name="op">The operator.</param> /// <param name="right">The expression on the right of the operator.</param> public BinaryOperation(SourceExpression left, BinaryOperator op, SourceExpression right) { this.Left = left; this.Operator = op; this.Right = right; }
public Condition(SourceExpression column, SqlOperator op, object value) { this.Field = column; this.Operator = op; AddValue(value); }
public Join(JoinType joinType, Table table, SourceExpression leftColumn, SourceExpression rightColumn) { this.JoinType = joinType; this.Table = table; this.Conditions.Add(new Condition(leftColumn, SqlOperator.Equals, rightColumn)); }
/// <summary> /// Initializes a new instance of the <see cref="OrderByExpression" /> class. /// </summary> /// <param name="expression">The expression that is ordered by.</param> /// <param name="direction">The direction of ordering.</param> public OrderByExpression(SourceExpression expression, OrderDirection direction) { this.Expression = expression; this.Direction = direction; }
/// <summary> /// Initializes a new instance of the <see cref="OrderByExpression" /> class. /// </summary> /// <param name="expression">The expression that is ordered by.</param> public OrderByExpression(SourceExpression expression) { this.Expression = expression; }
/// <summary> /// Initializes a new instance of the <see cref="ConvertFunction" /> class. /// </summary> /// <param name="expression">The expression to convert.</param> public ConvertFunction(SourceExpression expression) { this.Expression = expression; }