/// <summary>
/// Groups the by.
/// </summary>
/// <param name="columns">The columns.</param>
public void GroupBy(params string[] columns)
{
foreach (var column in columns)
{
GroupByColumns.Add(column);
}
}
public SelectQuery GroupBy(IEnumerable <string> groupByColumns)
{
foreach (string groupByColumn in groupByColumns)
{
GroupByColumns.Add(Query.ColumnSyntax(groupByColumn));
}
return(this);
}
public Query GroupBy(params string[] columns)
{
foreach (var item in columns)
{
GroupByColumns.Add(new Column(item));
}
return(this);
}
/// <inheritdoc />
public ISelectStringBuilder GroupBy(params string[] columnNames)
{
foreach (var columnName in columnNames)
{
GroupByColumns.Add(columnName);
}
return(this);
}
public SelectQuery GroupBy(string groupByColumn, params string[] groupByColumns)
{
GroupByColumns.Add(Query.ColumnSyntax(groupByColumn));
return(GroupBy(groupByColumns));
}
/// <summary>
/// Creates and adds a new Groupby clause to the current query object
/// </summary>
/// <param name="fieldName"></param>
public SelectQueryBuilder GroupBy(string fieldName)
{
GroupByColumns.Add(fieldName);
return(this);
}
/// <summary>
/// Adds a column to the GROUP BY clause.
/// </summary>
public SelectBuilder GroupBy(String column)
{
GroupByColumns.Add(column);
return(this);
}