Hibernate Community • View topic - Criteria API

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Criteria API - Distinct

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

dienstfuchs

Post subject: Criteria API - Distinct

Posted: Thu Nov 24, 2005 12:15 pm

Hello!

Is there any possibility to get distinct results in the Criteria API?

like in HQL: "select distinct...."

Thanks.

Stefan

Top

Balagan

Post subject:

Posted: Thu Nov 24, 2005 4:01 pm

Beginner

Joined: Wed Oct 05, 2005 5:35 am
Posts: 47
Location: France

Sure, with DistinctRootEntityResultTransformer:

Dim crit As ICriteria = my_session.CreateCriteria(type)
Dim A As New NHibernate.Transform.DistinctRootEntityResultTransformer
crit.SetResultTransformer(A)

Top

Ayende Rahien

Post subject:

Posted: Mon Nov 28, 2005 3:37 pm

Contributor

Joined: Sat Sep 24, 2005 11:25 am
Posts: 198

Where does this transform the query? Database or in the app?

Top

Balagan

Post subject:

Posted: Tue Nov 29, 2005 9:54 am

Beginner

Joined: Wed Oct 05, 2005 5:35 am
Posts: 47
Location: France

As far as I know - the app. It would get all results 1st and then "transform" them:

Code:

DEBUG 3088 NHibernate.Transform.DistinctRootEntityResultTransformer - transformed: 5 rows to: 5 distinct results

A "select distinct" in HQL would do it in the database - it would build a distinct query in relevant dialect.

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum