The instance produced by the factory depends on the presence of aggregation functions in the select list, the presence and nature of the group-by clause.
In case (1) and (2) there are no aggregation functions in the select clause.
Case (3) is without group-by and with aggregation functions and without non-aggregated properties in the select list:
![]() | |
---|---|
select sum(volume) |
Case (4) is without group-by and with aggregation functions but with non-aggregated properties in the select list:
![]() | |
---|---|
select price, sum(volume) |
Case (5) is with group-by and with aggregation functions and all selected properties are grouped-by. in the select list:
![]() | |
---|---|
select customerId, sum(volume) group by customerId |
Case (6) is with group-by and with aggregation functions and only some selected properties are grouped-by. in the select list:
![]() | |
---|---|
select customerId, supplierId, sum(volume) group by customerId |
The following tables list the members exposed by the ResultSetProcessorFactory type.
Public Methods
Name | Description | |
---|---|---|
![]() | Equals | (Inherited from Object.) |
![]() | GetHashCode | Serves as a hash function for a particular type. GetHashCode() is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
![]() ![]() | GetProcessor |
Returns the result set process for the given select expression, group-by clause and
having clause given a set of types describing each stream in the from-clause.
|
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | ToString | (Inherited from Object.) |