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