I don't think that's possible. Your design sounds a little funny to me, it seems more like Address should be it's own entity and there be a many-to-one between Customer and Address. Joining two tables into one entity is only really done when they share a primary key value. I don't think the underlying NHibernate feature is capable of handling your design.
On Fri, Feb 13, 2009 at 2:57 PM, Craig G <[email protected]> wrote: > > We are trying to get the "Entity spanning multiple tables" to work > with a slightly different scenario from the one in the examples > http://code.google.com/p/fluent-nhibernate/wiki/Examples, but are > having a problem trying to define the name of the foreighn key column > to be used when we perform a select query. > > Our schema is as follows: > > table Customer ( > Id int primary key > Name varchar(100), > CustomerAddressId int // Different from example > ) > > table CustomerAddress ( > CustomerAddressId int, // Different from example > Address varchar(100) > ) > > The basic difference from the one in the examples is that our foreign > key is from Customer to CustomerAddress instead of the other way > around. > > Our mapping looks like this: > > public CustomerMap() > { > Id(x => x.Id); > Map(x => x.Name); > WithTable("CustomerAddress", m => > { > m.WithKeyColumn("CustomerAddressId"); // Different > from example > m.Map(x => x.Address); > }); > } > > And the resulting SQL query is this: > > SELECT cust.Id, cust.Name, addr.Address > FROM cg_temp..Customer cust inner join cg_temp..CustomerAddress > addr > on cust.Id=addr.CustomerAddressId > > .. the problem is that on the 3rd line 'cust.Id' should be > 'cust.CustomerAddressId ' i.e. > 'on cust.CustomerAddressId =addr.CustomerAddressId'. > > Any ideas on how I would do 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 -~----------~----~----~----~------~----~------~--~---
