NHibernate HQL: How to use the new object constructor with 'distinct'?

Question

I need to use the HQL object constructor feature, e.g:

select new SomeClass(i.Id, i.Name) from Item i...

But I also need to use the distinct keyword, as there are joins further down in the query, e.g.:

select distinct i.Id from Item i

I have tried this: but it just causes an Antlr exception, so I assume it's invalid syntax:

select new SomeClass(distinct i.Id, i.Name) from Item i

Is this possible?

Related: http://stackoverflow.com/questions/6984135/hibernate-new-keyword-with-distinct — AlikElzin-kilaka, Feb 02 '16 at 11:17

score 3 · Answer 1 · answered Jul 06 '11 at 22:11

3

Ah, it looks like this works:

select distinct new SomeClass(i.Id, i.Name) from Item i...

answered Jul 06 '11 at 22:11

UpTheCreek

1 Answers1