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