14.0.0
andrew-at-octopus
released this
24 Jun 00:26
·
310 commits
to master
since this release
Added a GroupBy method on the IQueryBuilder and ISelectBuilder interfaces along with a simple implementation internally.
This is a "user be aware" method, as it is easy to create an invalid group by query in SQL.
Example usage:
CreateQueryBuilder<object>("Orders")
.GroupBy("OrderId")
.Column("OrderId")
.CalculatedColumn("COUNT (*)", "ItemCount")
.CalculatedColumn("COUNT (DISTINCT ItemCode)", "ItemCodes")
.ToList();