/// <summary> /// With open brackets, WITHOUT close brackets /// </summary> /// <param name="t"></param> /// <param name="tableAlias"></param> /// <returns></returns> public StringSQLBuilder AddInColumns(Type t) { var cBuilder = new ColumnsBuilder(this); cBuilder.GetAllColumns(t); Query = Query.Append("IN (", Columns); return(this); }
public StringSQLBuilder AddSelect(Type t, string tableAlias, IEnumerable <string> columnsAlias) { var cBuilder = new ColumnsBuilder(this); cBuilder.GetAllColumns(t, tableAlias, columnsAlias); Query = $"SELECT {Columns} "; return(this); }
public StringSQLBuilder AddSelectColumns(Type t, string tableAlias, IEnumerable <string> columnsAlias) { var cBuilder = new ColumnsBuilder(this); cBuilder.GetAllColumns(t, tableAlias, columnsAlias); Query = Query.Append(",", Columns, " "); return(this); }
public StringSQLBuilder AddSelect(Type t) { var cBuilder = new ColumnsBuilder(this); cBuilder.GetAllColumns(t); Query = $"SELECT {Columns} "; return(this); }
public StringSQLBuilder SelectColumns(Type t) { var cBuilder = new ColumnsBuilder(this); cBuilder.GetAllColumns(t); Query = Query.Append(",", Columns, " "); return(this); }
/// <summary> /// With open brackets, WITHOUT close brackets /// </summary> /// <param name="t"></param> /// <param name="tableAlias"></param> /// <returns></returns> public StringSQLBuilder InColumns(Type t, string tableAlias) { var cBuilder = new ColumnsBuilder(this); cBuilder.GetAllColumns(t, tableAlias); Query = Query.Append("IN (", Columns); return(this); }
/// <summary> /// With open brackets, WITHOUT close brackets /// </summary> /// <param name="t"></param> /// <returns></returns> public StringSQLBuilder InParameters(Type t) { var cBuilder = new ColumnsBuilder(this); cBuilder.GetAllColumns(t); MakeColumnsParameters(); Query = Query.Append("IN (", Columns); return(this); }
public StringSQLBuilder SelectColumns(Type t, string tableAlias, string columnsAlias) { var cBuilder = new ColumnsBuilder(this); string[] columnsAliasArray = new string[cBuilder.GetColumnsCount(t)]; for (int i = 0; i < cBuilder.GetColumnsCount(t); i++) { columnsAliasArray[i] = columnsAlias; } cBuilder.GetAllColumns(t, tableAlias, columnsAliasArray); Query = Query.Append(",", Columns, " "); return(this); }