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