CODEWITHSUNDEEP
nhibernate
x__dos
x__dos

Reputation: 1823

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

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

Upvotes: 1

Views: 1507

Answers (2)

Syd
Syd

Reputation: 1546

Have you tried using the Transformers class?

See section 16.1.5

Upvotes: 2

rebelliard
rebelliard

Reputation: 9611

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
            };

Upvotes: 1

Related Questions