/// <summary> /// Specifies the negative condition for matching the rows between the two tables to be joined. /// </summary> /// <param name="prev">A predecessor object.</param> /// <param name="condition">Defines the negative matching condition.</param> public static OnChainer OnNot(this IOn prev, Expression condition) { return(new OnChainer((Chainer)prev, condition.Not())); }
/// <summary> /// Specifies the negative condition for matching the rows between the two tables based on the comparison between the two scalar arguments. /// </summary> /// <param name="prev">A predecessor object.</param> /// <param name="argument1">Is the first argument.</param> /// <param name="argument2">Is the second argument.</param> public static OnChainer OnNot(this IOn prev, ScalarArgument argument1, ScalarArgument argument2) { return(new OnChainer((Chainer)prev, argument1, argument2, false)); }
/// <summary> /// Generates the expression of the equality between the two columns. If more than one key is specified than the equality expressions are combined with AND operator. /// </summary> /// <param name="prev">A predecessor object.</param> /// <param name="firstColumn">A column of the first equality expression.</param> /// <param name="otherColumns">Columns of other equality expressions.</param> public static ByChainer By(this IOn prev, ByArgument firstColumn, params ByArgument[] otherColumns) { return(new ByChainer((Chainer)prev, Common.MergeArrays <ByArgument>(firstColumn, otherColumns))); }