<class name="Task" table="Task">
      <id name="Id" column="Id" type="Int64">
         <generator class="identity"/>
      </id>
      <set name="Risorse" inverse="true" cascade="save-update">
         <key column="Task_Id"/>
         <one-to-many class="Risorsa"/>
      </set>
      <property name="StatoTask"/>
      <property name="TipoTask" type="Simplico.Business.Seteco.Entities.EnumTipoTask, SetecoEntities"/>
      <property name="DataInizio" type="Date"/>
      <property name="DataFine" type="Date"/>
      <property name="PercentualeCompletamento" type="Single"/>
   </class>

   <class name="Risorsa" table="Risorsa">
      <id name="Id" column="Id" type="Int64">
         <generator class="identity"/>
      </id>
      <many-to-one name="TaskGS" class="Task" column="Task_Id" foreign-key="fk_Risorsa_Task"/>
      <property name="DataInizio" type="Date"/>
      <property name="DataFine" type="Date"/>
      <property name="DataInserimento" type="Date"/>

      <joined-subclass name="RisorsaEconomica" table="RisorsaEconomica">
         <key column="Risorsa_Id"/>
         <property name="Valore" type="Decimal"/>
      </joined-subclass>

      <joined-subclass name="RisorsaUomo" table="RisorsaUomo">
         <key column="Risorsa_Id"/>
         <property name="Ore" type="Single"/>
         <many-to-one name="RelazioneGS" class="Simplico.Business.Anagrafica.Entities.Relazione" column="Relazione_Id" foreign-key="fk_Risorsa_Relazione"/>
      </joined-subclass>
   </class>

string qry = "SELECT sum(ris.Ore) FROM Task t INNER JOIN t.Risorse ris GROUP BY ris.DataInizio";

select sum(risorse1_2_.Ore) as x0_0_ from Task task0_ inner join Risorsa risorse1_ on task0_.Id=risorse1_.Task_Id group by  risorse1_.DataInizio

using System;
using System.Collections.Generic;
using System.Text;

namespace Simplico.Business.Seteco.Entities
{
    public abstract class Risorsa
    {
        private long m_id;
        protected Task m_task;
        protected DateTime m_dataInizio;
        protected DateTime m_dataFine;
        protected DateTime m_dataInserimento;

        public Risorsa() { }
        public virtual long Id { get { return m_id; } set { m_id = value; } }
        public virtual Task TaskGS { get { return m_task; } set { m_task = value; } }
        public virtual DateTime DataInserimento { get { return m_dataInserimento; } set { m_dataInserimento = value; } }
        public virtual DateTime DataInizio { get { return m_dataInizio; } set { m_dataInizio = value; } }
        public virtual DateTime DataFine { get { return m_dataFine; } set { m_dataFine = value; } }

    }
}


using System;
using System.Collections.Generic;
using System.Text;
using Simplico.Business.Anagrafica.Entities;
using Simplico.Business.ModuleJoin.Entities;
using Simplico.Persistence.NHibernate;
using NHibernate;
using System.Collections;
using Simplico.Business.Contabilita.Entities;

namespace Simplico.Business.Seteco.Entities
{
    public class RisorsaUomo : Risorsa
    {
        float m_ore;

        public RisorsaUomo() { }
        public virtual float Ore { get { return m_ore; } set { m_ore = value; } }
        public override DateTime DataFine { get { return DataInizio; } set { DataInizio = value; } }
    }
}

using System;
using System.Collections.Generic;
using System.Text;
using Simplico.Business.Entity;
using Iesi.Collections.Generic;

namespace Simplico.Business.Seteco.Entities
{
    public enum EnumStatoTask { APERTO, CHIUSO }
    public enum EnumTipoTask { PROGETTO_DEFINITIVO, DIREZIONE_LAVORI }

    public class Task
    {
        private long m_id;
        EnumTipoTask m_tipo;
        EnumStatoTask m_stato;
        ISet<Risorsa> m_risorse = new HashedSet<Risorsa>();
        DateTime m_dataInizio;
        DateTime m_dataFine;
        Opera m_opera;
        Commessa m_commessa;
        float m_completamento;

        public Task() { }
        public virtual long Id { get { return m_id; } set { m_id = value; } }
        public virtual EnumTipoTask TipoTask { get { return m_tipo; } set { m_tipo = value; } }
        public virtual ISet<Risorsa> Risorse { get { return m_risorse; } set { m_risorse = value; } }
        public virtual EnumStatoTask StatoTask { get { return m_stato; } set { m_stato = value; } }
        public virtual DateTime DataInizio { get { return m_dataInizio; } set { m_dataInizio = value; } }
        public virtual DateTime DataFine { get { return m_dataFine; } set { m_dataFine = value; } }
        public virtual float PercentualeCompletamento { get { return m_completamento; } set { m_completamento = value; } }
    }
}