NHibernate: returning List<EntityType> not List<Object[]> when using grouping

Question

when using Nhiberante Criteria API or HQL with grouping, query returns list of arrays of entity properties List<Object[]> at which grouping was made. If I need to return only certain property how can I do that? preferably with Nhiberane API if possible

Answer 1

With HQL, you just SELECT the properties you want:

var query = Session.CreateQuery("select p.Id, p.Price from Products p where p.Status = 'A'")
                   .List().Cast<object[]>();

It's similar with NHibernate.Linq:

var query = from p in Session.Linq<Product>()
            where p.Status == "A"
            select new
            {
                p.Id, p.Price
            };

Answer 2

Have you tried using the Transformers class?

See section 16.1.5