Linq group counting does not work

Try this as a workaround :

The Distinct().Count() workaround fails with multiple grouping key. It looks like we have no workaround for this case.

Fails with NotSupportedException: new <>f__AnonymousType4`2(ShippingDate = [100001].ShippingDate, ShippedTo = [100001].ShippedTo)
(Seems to be the type name put as the exception message. Fails at VisitExpression, at VisitNhDistinct in HqlGeneratorExpressionTreeVisitor.)

Indeed, this would require a sub query in the from statement, which is unsupported by HQL as far as I know.

This would imply below query can not be supported:

I wonder then if NHibernate should really try to translate the "unique grouping key then count" case to a "distinct then count", as the more general group by case would still fails.

Following query, tried as a workaround, fails too:

It issues:

This means this bug likely affects all aggregates.

Hi,
Is this issue fixed?, or anyone working on it ?

@Oskar Berggren he said:

"The latest version does not support this feature, and hope to see this feature as soon as possible!
NHibernate team, refuel!"