NHibernate one-to-many criteria query

Question

Suppose I have a Post class and a Tag class. The relationship between Post and Tag is one-to-many. How can I write a Hibernate query to retrieve a List of Post objects which have a given Tag?

public IList<Post> FindByTag(Tag tag) { IList<Post> posts; using (ISession session = HibernateUtil.GetSessionFactory().OpenSession()) { posts = session.CreateCriteria<Post>() .Add(...) // what Criteria do I add? .List<Post>(); } return posts; }

Vadim · Accepted Answer · 2011-01-15 23:06:40Z

You need to add an Alias or Criteria

session.CreateCriteria<Post>() .CreateAlias("Tags", "tag") .Add(Restrictions.Eq("tag.Id", tag.Id)) .List<Post>();

Collectives™ on Stack Overflow

NHibernate one-to-many criteria query

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related