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].
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en.
