Hibernate Community • View topic - Criteria Query with DISTINCT with Subquery

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Criteria Query with DISTINCT with Subquery

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

sedge

Post subject: Criteria Query with DISTINCT with Subquery

Posted: Fri Apr 16, 2010 1:09 am

Newbie

Joined: Fri Apr 16, 2010 12:43 am
Posts: 2

Starting with Ayende's article at
http://ayende.com/Blog/archive/2009/05/ ... mples.aspx
and using the example Criteria Query:

Code:

var blogs = s.CreateCriteria<Blog>()
    .Add(Subqueries.PropertyIn("id",
        DetachedCriteria.For<Post>()
            .SetProjection(Projections.Property("Blog.id"))
            .CreateCriteria("User")
            .Add(Restrictions.Eq("Username","Ayende"))
        ))
    .List<Blog>();

I have this working OK. Now I'd like to extend it to perform a DISTINCT query on some columns in the result set and I haven't been able to figure it out. Can anyone help?

Thanks
Steve

Top

sedge

Post subject: Re: Criteria Query with DISTINCT with Subquery

Posted: Fri Apr 16, 2010 4:08 am