C# (CSharp) Figlotech.Data Qb.Fmt Examples

Example #1

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

Example #2

 public static QbFmt And()
 {
     return(Qb.Fmt("AND"));
 }

Example #3

 public static QbFmt Or()
 {
     return(Qb.Fmt("OR"));
 }

Example #4

 public static QbFmt Le(string column, object value)
 {
     return(Qb.Fmt($"{column}<=@{paramId}", value));
 }

Example #5

File: IQueryBuilder.cs Project: figloalds/Figlotech

 public static IQueryBuilder ToQueryBuilder(this string query, params object[] args)
 {
     return(Qb.Fmt(query, args));
 }