public SqlAggregateSubqueryExpression(string groupByAlias, Expression aggregateInGroupSelect, SqlSubqueryExpression aggregateAsSubquery)
: base(aggregateAsSubquery.Type)
{
this.AggregateInGroupSelect = aggregateInGroupSelect;
this.GroupByAlias = groupByAlias;
this.AggregateAsSubquery = aggregateAsSubquery;
}
public SqlAggregateSubqueryExpression(string groupByAlias, Expression aggregateInGroupSelect, SqlSubqueryExpression aggregateAsSubquery)
: base(aggregateAsSubquery.Type)
{
this.AggregateInGroupSelect = aggregateInGroupSelect;
this.GroupByAlias = groupByAlias;
this.AggregateAsSubquery = aggregateAsSubquery;
}
protected override Expression VisitSubquery(SqlSubqueryExpression subquery)
{
if (subquery.Select != null)
{
Debug.Assert(subquery.Select.Columns.Count == 1);
this.MarkColumnAsUsed(subquery.Select.Alias, subquery.Select.Columns[0].Name);
}
return base.VisitSubquery(subquery);
}
protected virtual Expression VisitSubquery(SqlSubqueryExpression subquery)
{
var select = (SqlSelectExpression)this.Visit(subquery.Select);
if (select != subquery.Select)
{
return(new SqlSubqueryExpression(subquery.Type, select));
}
return(subquery);
}
protected override Expression VisitSubquery(SqlSubqueryExpression subquery)
{
SqlSubqueryExpression current;
if (!TryGetCurrent(subquery, out current))
{
return(subquery);
}
currentObject = current.Select;
VisitSelect(subquery.Select);
currentObject = current;
return(subquery);
}
protected override Expression VisitSubquery(SqlSubqueryExpression expression)
{
SqlSubqueryExpression current;
if (!TryGetCurrent(expression, out current))
{
return expression;
}
if (!(this.result &= current.NodeType == expression.NodeType))
{
return expression;
}
if (!(this.result &= current.Type == expression.Type))
{
return expression;
}
this.currentObject = current.Select;
this.VisitSelect(expression.Select);
if (!this.result)
{
return expression;
}
this.currentObject = current;
return expression;
}
protected override Expression VisitSubquery(SqlSubqueryExpression subquery)
{
this.Write("(");
using (this.AcquireIndentationContext())
{
this.Visit(subquery.Select);
this.WriteLine();
}
this.Write(")");
return subquery;
}
protected virtual Expression VisitSubquery(SqlSubqueryExpression subquery)
{
var select = (SqlSelectExpression)this.Visit(subquery.Select);
if (select != subquery.Select)
{
return new SqlSubqueryExpression(subquery.Type, select);
}
return subquery;
}
protected override Expression VisitSubquery(SqlSubqueryExpression subquery)
{
return subquery;
}
protected override Expression VisitSubquery(SqlSubqueryExpression subquery)
{
// Don't gather inside scalar & exists
return subquery;
}
protected override Expression VisitSubquery(SqlSubqueryExpression subquery)
{
return(base.VisitSubquery(subquery));
}
protected override Expression VisitSubquery(SqlSubqueryExpression subquery)
{
// Ignore aggregates in sub queries
if (this.hasAggregate || ignoreInSubqueries)
{
return subquery;
}
return Visit(subquery);
}
