Assign objects from query result

mummu · **Joined:** Thu Aug 27, 2009 6:28 am **Posts:** 19

Hi,
I am having the student class which having FName,LName,num. Now I need to get FName,LName,num,Total(sum of num).
If i do like below I got the objects in the list

Code:

    var Query = "select std from student std"
      IList< student> list = HibernateTemplate.Find< student>(Query);

But i need to get the total also, so I have added total in the class. then If i do like

Code:

var Query = "select std.FName, std.LName,std.num,sum(std.num) from student std"
      IList< student> list = HibernateTemplate.Find< student>(Query);

Its shows an exception.
How to add the assign the additional properties into student class which should not map with the database column.

Thanks&Regards
Nizam deen

wolli · **Posted:** Mon Sep 14, 2009 2:30 am

You can use a formula for a property:

http://nhforge.org/doc/nh/en/index.html#mapping-declaration-property

But I'm not sure if that's the solution to your problems, because afaik using sum like you want to requires a group by clause. Maybe you need a SQL query and map the result set accordingly:

http://nhforge.org/doc/nh/en/index.html#querysql-creating