DmGroupQuery`2
Namespace: MJCZone.DapperMatic.Dml
Assembly: MJCZone.DapperMatic
Summary
Groups of a query's rows, one <c>GROUP BY</c>: filtered by <c>Having</c>, ordered and paged, and read by <c>Select</c> over each group's <c>Key</c> and aggregates (<c>Count</c>, <c>Sum</c>, <c>Min</c>, <c>Max</c>, <c>Average</c>, <c>Any</c>, <c>All</c>, each after any <c>Where</c>).
sealed public
Contents
Methods (13)
Methods
| Method | Summary |
|---|---|
| Having | |
| OrderBy | |
| OrderByDescending | |
| ThenBy | |
| ThenByDescending | |
| Skip | Skips groups. |
| Take | Returns at most a number of groups. |
| Select | |
| CountAsync | Counts the groups. |
| GetType | |
| ToString | |
| Equals | |
| GetHashCode |
Having
csharp
Having()OrderBy
csharp
OrderBy()OrderByDescending
csharp
OrderByDescending()ThenBy
csharp
ThenBy()ThenByDescending
csharp
ThenByDescending()Skip
Skips groups.
csharp
DmGroupQuery<TKey, TElement> Skip(int count)Parameters
- count (int) - The number of groups to skip.
Returns
Type: DmGroupQuery<TKey, TElement>
The query.
Take
Returns at most a number of groups.
csharp
DmGroupQuery<TKey, TElement> Take(int count)Parameters
- count (int) - The most groups to return.
Returns
Type: DmGroupQuery<TKey, TElement>
The query.
Select
csharp
Select()CountAsync
Counts the groups.
csharp
Task<long> CountAsync(IDbTransaction tx, CancellationToken cancellationToken)Parameters
- tx (IDbTransaction) - The transaction to use, or null.
- cancellationToken (CancellationToken) - The cancellation token.
Returns
Type: Task<long>
The number of groups.
GetType
csharp
GetType()ToString
csharp
ToString()Equals
csharp
Equals()GetHashCode
csharp
GetHashCode()