I need help with Projection

bajulio88 · **Joined:** Tue Jul 25, 2006 2:50 am **Posts:** 11

Hibernate version:
1.2.0

Hellow Forum, excuse-me for my English. I have a problem with projection.
I don´f know how can I use this utility to select 1 field of a entity.
Any know any examples??
I don´t know where i can find a good documentation.

Thanks

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

If you downloaded the source, you can look in the Unit Tests for some examples of Projections usage.
Here is a snippet that gets the count for the FirstName property on a Person that equals "Mark":

Code:

            ICriteria criteria = Session.CreateCriteria(typeof (Person));
            criteria.Projection = Projections.Count("FirstName");
            criteria.Add(Expression.Eq("FirstName", "Mark"));

You can also chain projections together using
Projections.ProjectionList().Add(Projections.Count(<propertyName>).Add(...)