tags:

views:

9

answers:

0
Q: 

join using setfetchmode

I have 2 entities that do not have an association in there mapping files, but one enitie's primary key is a foreign key for the other entity. Can I get an example of a critera that results in the join of the two tables? Is it possible to use the getfetchmode functionality of the criteria to accomplish this? Can a restriction be added that are part of eihter eniities? And finally, what type of structure/object is the result of the .list method?

related questions

NHibernate Criteria API, Projections and result
Do you know of anyway to get a distinct result set without using the ResultTransformer when using SetFirstResult and SetMaxResults?
Is there any easy way to convert Criteria to HQL?
Querying on Collection with Nhibernate Criteria Api ?
CreateCriteria and MONTH
NHibernate: can't successfully set lazy loading
Hibernate Criteria API - HAVING clause work arounds
How can I access to the properties of an object list returned by criteria query inside of itself query
Symfony Propel criteria
Getting DATEPART in HQL or Criteria ?
How to set more than 2 Expression in Expression.Or
Criteria question with NHibernate
hibernate criteria - querying tables in n:m relationship
How do IN () statements work in NHibernate? (Using Criteria)
How do I limit the result set being pulled back by NHibernate's GetByCriteria?
How to a write a Criteria query with multiple joins involved
Hibernate transform SQL to Criteria
How to get distinct results in hibernate with joins and row-based limiting (paging)?
NHibernate 2.0.1 Criteria: IsNull restriction throwing exception
Querying ManyToMany relationship with Hibernate Criteria
How to use MySQL functions in Propel
Hibernate: Criteria vs. HQL
Hibernate -- load an object based on a member object's field
Hibernate Query By Example and Projections
Hibernate criteria _ how to use criteria to return only one element of an object instead the entire object