NHibernate Criteria Query - Select Distinct

10k Views Asked by At

I have a Person entity belongs to a person has a Country, I want to select all the distinct countries that have people in them. Easy in HQL

select distinct p.Country from Person p

How can I do this using a Criteria Query?

1

There are 1 best solutions below

2
On BEST ANSWER
criteria.SetProjection(Projections.Distinct(Projections.Property("Country")));