public static Condition Any(ColumnItem actualColumn, Select expected)
{
return(new Condition(ConditionType.Any, actualColumn, expected));
}
protected Condition(ConditionType condition, Select item)
{
ConditionType = condition;
Item = item;
}
protected Condition(ConditionType condition, ColumnItem column, Select item)
{
ConditionType = condition;
Column = column;
Item = item;
}
public static Condition NotIn(ColumnItem actualColumn, Select select)
{
return(new Condition(ConditionType.NotIn, actualColumn, select));
}
public static Condition NotExists(Select select)
{
return(new Condition(ConditionType.NotExists, select));
}
public static Where NotIn(string coulmn, Select select)
{
return(new Where(Condition.NotIn(coulmn, select)));
}
/// <summary>
/// The ALL operator returns TRUE if all of the subquery values meet the condition.
/// </summary>
/// <param name="column">the column to look at</param>
/// <param name="select">the SELECT statement to check on</param>
public static Where All(string column, Select select)
{
return(new Where(Condition.All(column, select)));
}
/// <summary>
/// The EXISTS operator is used to test for the existence of any record in a subquery.
/// The EXISTS operator returns true if the subquery returns no records.
/// </summary>
/// <param name="select">the SELECT statement to check on</param>
public static Where NotExists(Select select)
{
return(new Where(Condition.NotExists(select)));
}