Hi.

This question is really not related to Fluent NHibernate, but to NHibernate itself. However, I have an idea on how you can solve it. Use HQL to build your query and use the "with" keyword as very briefly explained here:

http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html#queryhql-joins


-Asbjørn


On Tue, 04 Jan 2011 23:23:34 +0100, Mike <[email protected]> wrote:

how do I add a JOIN in the map where the keys are not the primary keys. I
also need to have two keys in the join clause.


select *
from member m
  inner join codes c on *m.status = c.status and m.class = c.class*


when I try to use the JOIN ("codes", m=>{} ) the primary key is allays
used....anyway around this?

--
You received this message because you are subscribed to the Google Groups "Fluent 
NHibernate" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/fluent-nhibernate?hl=en.

Reply via email to