Hibernate Community • View topic - NewBie Question about querying

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

NewBie Question about querying

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

jbliss1234

Post subject: NewBie Question about querying

Posted: Tue Sep 20, 2005 5:21 pm

Beginner

Joined: Mon Sep 26, 2005 5:57 pm
Posts: 39

Let us say we have a Order class that has a collection of Items.

I would like to query for all Orders that have a particular Item in its Items collection. I definitely want to use the Order class as the entry class for the criteria. How can I do that?

Thanks

Top

sergey

Post subject:

Posted: Tue Sep 20, 2005 5:24 pm

Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic

Try this (in the new 1.0-rc1 version):

Code:

ISession
  .CreateCriteria(typeof(Order))
    .CreateCriteria(typeof(Item))
      .Add(Expression.Eq("id", itemId))
  .List();

Top

gerrod

Post subject:

Posted: Fri Sep 23, 2005 3:27 pm

Newbie

Joined: Tue Sep 06, 2005 11:41 pm
Posts: 7
Location: New York

You can also try this (as HQL):

Code:

select order
from myNamespace.Orders as order
inner join order.Items as item
where item.Id = ....

Obviously, insert the Id of your item where the dots are. Hope this helps; I've spent all day working it out for myself :-)

Top

paulk

Post subject:

Posted: Mon Sep 26, 2005 10:14 am

sergey wrote:

Try this (in the new 1.0-rc1 version):

Code:

ISession
  .CreateCriteria(typeof(Order))
    .CreateCriteria(typeof(Item))
      .Add(Expression.Eq("id", itemId))
  .List();

I already install the 1.0-rc1 version and I get an error on the second createCriteria, a string parameter is expected. any help would be appreciate

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum