public static IWhere Where(this Select select, string column, SqlOperator sqlOperator, object value) { Clause clause = new Clause(select.Parameters, column, sqlOperator, value); return(select.Where(clause)); }
public static Select RightJoin(this Select select, string joinOn, string predicate) { return(Join(select, JoinType.Right, joinOn, predicate)); }
public static Select Join(this Select select, JoinType joinType, string joinTo, string predicate) { return(select.Join($"{joinType.ToString().ToLowerInvariant()} join {joinTo} on {predicate}")); }
public static IWhere Where(this Select select, string column, object value) { return(Where(select, column, SqlOperator.Equal, value)); }