public static Condition Any(ColumnItem actualColumn, Select expected)
{
return(new Condition(ConditionType.Any, actualColumn, expected));
}
public static Condition NotBetween(ColumnItem column, object start, object end)
{
return(new Condition(ConditionType.NotBetween, column, start, end));
}
protected Condition(ConditionType condition, ColumnItem column, object item2)
{
ConditionType = condition;
Column = column;
Item2 = item2;
}
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));
}
protected Condition(ConditionType condition, ColumnItem column)
{
ConditionType = condition;
Column = column;
}
public static Condition IsNotNull(ColumnItem actualColumn)
{
return(new Condition(ConditionType.IsNotNull, actualColumn));
}
public static Condition Like(ColumnItem actualColumn, object like)
{
return(new Condition(ConditionType.Like, actualColumn, like));
}
public static Condition LessThan(ColumnItem actualColumn, object expected)
{
return(new Condition(ConditionType.LessThan, actualColumn, expected));
}
public static Condition NotEqual(ColumnItem actualColumn, object expected)
{
return(new Condition(ConditionType.NotEqual, actualColumn, expected));
}
/// <summary>
/// Sortde descending by the column
/// </summary>
/// <param name="columnName">the column to order by</param>
public static OrderBy DESC(ColumnItem columnName, params ColumnItem[] columnNames)
{
return(new OrderBy(OrderByType.DESC, columnName, columnNames));
}
