How to add groupby in query over nhibernate?

asp.net, c#, nhibernate, queryover, sql

Solution

You can use `SelectList` for it:

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

Problem

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...

Original source