NHibernate HQL: How to use the new object constructor with 'distinct'?
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
开发者_C百科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?
Ah, it looks like this works:
select distinct new SomeClass(i.Id, i.Name) from Item i...
精彩评论