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