IFulltextQuery(TDocument).GroupBy(TKey) Method (Expression(Func(TDocument, TKey)))

IFulltextQueryTDocumentGroupByTKey Method (ExpressionFuncTDocument, TKey)

Group the results of this query by the given key.

Namespace: SphinxConnector.FluentApi
Assembly: SphinxConnector (in SphinxConnector.dll) Version: 3.12.6

Syntax

IFulltextQuery<TDocument> GroupBy<TKey>(
	Expression<Func<TDocument, TKey>> keySelector
)

Function GroupBy(Of TKey) ( 
	keySelector As Expression(Of Func(Of TDocument, TKey))
) As IFulltextQuery(Of TDocument)

Parameters

keySelector: Type: System.Linq.ExpressionsExpressionFuncTDocument, TKey
A function to extract the key from a document.

Type Parameters

TKey: The type of the key returned by the function that is represented by keySelector.

Return Value

Type: IFulltextQueryTDocument
The current instance.

Exceptions

Exception	Condition
ArgumentNullException	Occurs when keySelector is null.
InvalidOperationException	Occurs when this method called more than once for query.

Examples

To group by multiple attributes, create an anonymous type with the attributes to group by:

Copy

using (IFulltextSession fulltextSession = fulltextStore.StartSession())
{
    var results = fulltextSession.Query<Product>().
                                  Match("a product").
                                  GroupBy(p => new { p.CategoryId, p.VendorId }).
                                  Select(p => new
                                  {
                                      p,
                                      Count = Projection.Count()        
                                  }).ToList();
 }

Note that grouping by multiple attributes is only supported with Sphinx 2.1.2 and above.

Reference

IFulltextQueryTDocument Interface

GroupBy Overload

SphinxConnector.FluentApi Namespace

IFulltextQueryTDocumentWithinGroupOrderByTKey(ExpressionFuncTDocument, TKey)

IFulltextQueryTDocumentWithinGroupOrderByDescendingTKey(ExpressionFuncTDocument, TKey)