Hello all...
I have the follow HQL:

So, I got all distincts estates from my Table!


I´m trying to do the same thing with ICriteria... I done that:


I think with SetResultTransformer I get distinct entitys... But I need distinct Estates.

Example:
Table:
1 - X - 30500 - 2006
2 - Y - 43000 - 2004
3 - W - 2300 - 2002
4 - X - 299 - 2003
5 - W - 876 - 1999

I´d like to return only X,Y,W once like in previous HQL... Help?

[]´s

Just to let the things clear, I´d like do that(HQL) with ICriteria:



Please help!

I found setProjection function on Hibernate's v3 documentation ... Thats exactly what I need... How can I use that function on NH?

I need to do something like that

My guess is that maybe it isn't possible because that is a feature that is new to Hibernate 3 and NHibernate is based on Hibernate 2.1. That's just a guess though. Hopefully someone else will chime in and state more authoritively whether you can do it.

If nothing else, I guess you could just use StringBuilder and build up the HQL query at run-time, but, I'm guessing this is pretty obvious to you and that's not what you want.

Ty for the reply!
Yes, I can do that easily with HQL, but in my case I´d like to use ICriteria! Anyone more can help-me?


ty