NHibernate Criteria Query - Select Distinct

nhibernate criteria icriteria
reach4thelasers picture reach4thelasers · Nov 18, 2009 · Viewed 9.9k times · Source

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?

Answer

Derek Slager picture Derek Slager · Nov 18, 2009 
criteria.SetProjection(Projections.Distinct(Projections.Property("Country")));

Related questions

NHibernate - CreateCriteria vs CreateAlias

Assuming the following scenario: class Project{ public Job Job; } class Job{ public Name; } Assuming I want to use the Criteria API to search for all projects whose Job has the name "sumthing". I could use the CreateAlias to create an …

Read More
Querying on Collection with Nhibernate Criteria Api?

I have an "Estate" entity, and this entity has a collection "EstateFeatures"(type:EstateFeature) and EstateFeature has a property "MyFeatureValue". Note: These are the limited properties for the question. All Entities has an Id and all necesarry etc Estate IList&…

Read More
Hibernate Criteria for "in subselect"

I'm trying to do something like this, but using Criteria instead of HQL: select user from User where user in ( select user from UserDomain where domain.id = "XXX" ) User being an entity having a one-to-many relationship to the join table …

Read More