public SqlQueryWhere(SqlQueryTable <T> table, string columnName, Dictionary <string, object> parameters)
{
_column = columnName;
_table = table;
_where = new StringBuilder();
_parameters = parameters;
}
public SqlQueryOrderBy(SqlQueryTable <T> table, string column, string alias, bool descending = false)
{
_table = table;
_column = column;
_direction = descending ? "DESC" : "ASC";
_alias = alias;
_thenBy = new StringBuilder();
}
public SqlQueryRightJoin(SqlQueryTable <T> tableOne, SqlQueryTable <S> tableTwo) : base(tableOne, tableTwo)
{
}
public SqlQueryInnerJoin(SqlQueryTable <T> tableOne, SqlQueryTable <S> tableTwo) : base(tableOne, tableTwo)
{
}
protected SqlQueryJoin(SqlQueryTable <T> tableOne, SqlQueryTable <S> tableTwo)
{
TableTwo = tableTwo;
TableOne = tableOne;
}
public SqlQueryTable <T> From(string tableName, string schema)
{
return(_from = new SqlQueryTable <T>(_queryBuilder, tableName, schema));
}