public override SqlObject Visit(SqlGroupByClause sqlGroupByClause)
{
SqlScalarExpression[] expressions = new SqlScalarExpression[sqlGroupByClause.Expressions.Count];
for (int i = 0; i < sqlGroupByClause.Expressions.Count; i++)
{
expressions[i] = sqlGroupByClause.Expressions[i].Accept(this) as SqlScalarExpression;
}
return(SqlGroupByClause.Create(expressions));
}
public static SqlQuery Create(
SqlSelectClause selectClause,
SqlFromClause fromClause,
SqlWhereClause whereClause,
SqlGroupByClause groupByClause,
SqlOrderbyClause orderByClause,
SqlOffsetLimitClause offsetLimitClause)
{
return(new SqlQuery(selectClause, fromClause, whereClause, groupByClause, orderByClause, offsetLimitClause));
}
public override void Visit(SqlGroupByClause sqlGroupByClause)
{
this.writer.Write("GROUP BY ");
sqlGroupByClause.Expressions[0].Accept(this);
for (int i = 1; i < sqlGroupByClause.Expressions.Count; i++)
{
this.writer.Write(", ");
sqlGroupByClause.Expressions[i].Accept(this);
}
}
public override int Visit(SqlGroupByClause sqlGroupByClause)
{
int hashCode = SqlGroupByClauseHashCode;
for (int i = 0; i < sqlGroupByClause.Expressions.Count; i++)
{
hashCode = CombineHashes(hashCode, sqlGroupByClause.Expressions[i].Accept(this));
}
return(hashCode);
}
private SqlQuery(
SqlSelectClause selectClause,
SqlFromClause fromClause,
SqlWhereClause whereClause,
SqlGroupByClause groupByClause,
SqlOrderbyClause orderbyClause,
SqlOffsetLimitClause offsetLimitClause)
{
this.SelectClause = selectClause ?? throw new ArgumentNullException(nameof(selectClause));
this.FromClause = fromClause;
this.WhereClause = whereClause;
this.GroupByClause = groupByClause;
this.OrderbyClause = orderbyClause;
this.OffsetLimitClause = offsetLimitClause;
}
protected SqlQuery(
SqlSelectClause selectClause,
SqlFromClause fromClause,
SqlWhereClause whereClause,
SqlGroupByClause groupByClause,
SqlOrderbyClause orderbyClause,
SqlOffsetLimitClause offsetLimitClause)
: base(SqlObjectKind.Query)
{
if (selectClause == null)
{
throw new ArgumentNullException($"{nameof(selectClause)} must not be null.");
}
this.SelectClause = selectClause;
this.FromClause = fromClause;
this.WhereClause = whereClause;
this.GroupByClause = groupByClause;
this.OrderbyClause = orderbyClause;
this.OffsetLimitClause = offsetLimitClause;
}
