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