Count no. of objects using CriteriaAPI

nokiola · **Joined:** Sun Jun 19, 2005 2:21 pm **Posts:** 21

Hello,

Does anyone know how to make a generic routine which counts the number of objects from a table using CriteriaAPI?

I need something looking like this:

public int GetObjectsCount (Type obj)
{
....
}

If it is not possible to do this using CriteriaAPI, does anyone know a workaround using HQL?

Regards,
Robert

mnichols · **Joined:** Mon Aug 21, 2006 9:18 am **Posts:** 179

in HQL

Code:

StringBuilder query = new StringBuilder();
query.Append("select count(*) from Email as e where        e.Text='").Append(text).Append("'");            
query.Append(" group by e.Text");            
IQuery q = Session.CreateQuery(query.ToString());           
 int number = q.List().Count;            
return number;

just don't forget the aggregate (group by) expression.

Hope this helps

preuse · **Joined:** Thu Aug 31, 2006 2:54 pm **Posts:** 2

What you want is projection as it is implemented in hibernate. This is not yet implemented in nhibernate, but i've uploaded a patch to nh-617 to make this possible. So, if you really want it, download the nhibernate sources, and apply the patch.

gcook1@shaw.ca · **Joined:** Tue Feb 07, 2006 4:27 pm **Posts:** 69

preuse wrote:

What you want is projection as it is implemented in hibernate. This is not yet implemented in nhibernate, but i've uploaded a patch to nh-617 to make this possible. So, if you really want it, download the nhibernate sources, and apply the patch.

Do you know what the timelines are for having Projections added to the main build/release cycle?

preuse · **Joined:** Thu Aug 31, 2006 2:54 pm **Posts:** 2

Well,

Sergey applied the patch. You can either dowload the sources and compile them, or wait until the 1.2 beta 1 is released.
I have no idea for the beta 1 timeline, soon I hope.