public void Dispose() { column?.Dispose(); column = null; Parameters.Clear(); Parameters = null; }
public SqlQueryOrderBy <T> OrderByDesc <TProp>(Expression <Func <T, TProp> > expression, string tableAlias = null) { var orderByClause = new SqlQueryOrderBy <T>(this, SqlQueryColumn.GetColumnName(expression), tableAlias, true); _orderBy = orderByClause; return(_orderBy); }
public SqlQueryColumn <T> SelectTopStar(int topCount) { top = topCount; column = new SqlQueryColumn <T>(this); column.Column("*"); return(column); }
public SqlQueryWhere <T, TProp> AndWhere <TProp>(Expression <Func <T, TProp> > expression, string tableAlias) { var col = $"[{tableAlias}].[{SqlQueryColumn.GetColumnName(expression)}]"; var andWhere = new SqlQueryWhere <T, TProp>(this, col, _queryBuilder.Parameters); _ands.Add(andWhere); return(andWhere); }
public virtual SqlQueryTable <T> On <TProp, SProp>(Expression <Func <T, TProp> > expression1, Expression <Func <S, SProp> > expression2) { var t1Alias = !string.IsNullOrEmpty(TableOne.Alias) ? $"[{TableOne.Alias}]." : ""; var t2Alias = !string.IsNullOrEmpty(TableTwo.Alias) ? $"[{TableTwo.Alias}]." : ""; OnCondition = $"ON {t1Alias}[{SqlQueryColumn.GetColumnName(expression1)}] = {t2Alias}[{SqlQueryColumn.GetColumnName(expression2)}]"; return(TableOne); }
public SqlQueryWhere <T, TProp> AndWhere <TProp>(Expression <Func <T, TProp> > expression) { var aliasClause = !string.IsNullOrEmpty(Alias) ? $"[{Alias}]." : ""; var col = $"{aliasClause}[{SqlQueryColumn.GetColumnName(expression)}]"; var andWhere = new SqlQueryWhere <T, TProp>(this, col, _queryBuilder.Parameters); _ands.Add(andWhere); return(andWhere); }
public SqlQueryOrderBy <T> ThenByDesc <TProp>(Expression <Func <T, TProp> > expression) { if (!string.IsNullOrEmpty(_table.Alias)) { _thenBy.Append($", [{_table.Alias}].[{SqlQueryColumn.GetColumnName(expression)}] DESC"); } else { _thenBy.Append($", [{SqlQueryColumn.GetColumnName(expression)}] DESC"); } return(this); }
public SqlQueryColumn <T> SelectStar() { column = new SqlQueryColumn <T>(this); column.Column("*"); return(column); }
public SqlQueryColumn <T> Select() { return(column = new SqlQueryColumn <T>(this)); }
public SqlQueryColumn <T> Column <TProp>(Expression <Func <T, TProp> > expression) { AddColumn(SqlQueryColumn.GetColumnName(expression), null); return(this); }
public SqlQueryColumn <T> Column <TProp>(Expression <Func <T, TProp> > expression, string tableAlias) { AddColumn(SqlQueryColumn.GetColumnName(expression), tableAlias); return(this); }