First ask yourself this .... is this possible in nhibernate hbms ? If not then fnh won't do this ... if so then it could be done ....
Honestly I have never tried it On Jan 5, 2011 8:58 AM, "Mike" <[email protected]> wrote: > I was wondering if this would be a good modification to the JOIN. I looks > like FH currently does not support this. I would like to be able to join to > a table using columns that are NOT the primary key. The resulting sql > would be the following (specifically the inner join): > > select ... > from member this_ > * inner join CodeLookup this_1_ on this_.status = this_1_.status and > this_.code = this_1_.code* > where .... > > public class MemberMap : ClassMap<Member> > { > public MemberMap() > { > Table("member"); > Id(x=> x.id); > Map(x=>x.name); > Join("CodeLookup", m=> > { > *m.ParentKeyColums("status","code");* > * m.ChildKeyColums("status","code");* > ... > }); > } > } > > Thanks. > > -- > 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]<fluent-nhibernate%[email protected]> . > For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en. > -- 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.
