How to add groupby in query over nhibernate?

Question

How can I add groupby Id to this nhibernate code because I'm new with it and there is many way but none work for me.

.Select(Projections.Sum(() => ServiceOrderItem.WorkTime), 
    Projections.ProjectionList().Add(Projections.Property(
        () => ServiceOrder.Id).WithAlias(() => TechnicianWorkTime.Id))
    )

There will be more in ProjectionList...

Console

Very difficult to answer without whole query, class definitions and expected result. Maybe this could help you https://mcmap.net/q/1923437/-nhibernate-aggregate-query-for-one-to-many-relation – Radiotelegram

Answer 1

You can use SelectList for it:

query.SelectList(list => list
  .SelectGroup(() => ServiceOrder.Id)
  .SelectSum(() => ServiceOrderItem.WorkTime));

Martijn

Answer 2

You can do this as well:

objQuery = objQuery.SelectList(list => list.SelectGroup((x => x.Id)));

Coats