private static QbFmt ListQueryFunction <T>(string column, List <T> o, Func <T, object> fn, bool isIn) { if (!o.Any()) { return(Qb.Fmt(isIn ? "FALSE" : "TRUE")); } var retv = Qb.Fmt($"{column} {(isIn ? "IN" : "NOT IN")} ("); for (int i = 0; i < o.Count; i++) { retv.Append($"@{paramId}", fn?.Invoke(o[i])); if (i < o.Count - 1) { retv.Append(","); } } retv.Append(")"); return(retv); }
public static QbFmt And() { return(Qb.Fmt("AND")); }
public static QbFmt Or() { return(Qb.Fmt("OR")); }
public static QbFmt Le(string column, object value) { return(Qb.Fmt($"{column}<=@{paramId}", value)); }
public static IQueryBuilder ToQueryBuilder(this string query, params object[] args) { return(Qb.Fmt(query, args)); }