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