How to use CountProjection ?

Papy214 · **Joined:** Fri Feb 29, 2008 9:36 am **Posts:** 40

Hi,

Today, to get a number of row on a "criteria", I use:

Code:

return session.CreateSQLQuery("select count(*) from users where id_profile = :idprofile")
.SetParameter("idprofile", (Int32)value, Hibernate.NHibernateUtil.Int32)
.UniqueResult<System.Int64>();

I have found the CountProjection class.

Is it a better way to get the count ?

Problem, if I code:

NHibernate.Expression.CountProjection count = new CountProjection();

I get an error on protection level for
NHibernate.Expression.CountProjection.CountProjection(string)

How to use this class please ?

Papy!

wolli · **Posted:** Fri Jul 04, 2008 11:08 am

Try this:

Code:

session.CreateCriteria(typeof(Users))
    .Add(Expression.Eq("IdProfile", value)
    .SetProjections(Projections.RowCount()).UniqueResult<long>();

Papy214 · **Joined:** Fri Feb 29, 2008 9:36 am **Posts:** 40

Thanks a lot ! you're great !