Hello together...

I'm trying since quite a while to do a relative simple mapping, but without success. Here is what I want:

I got a table "Country", it contains three fields: ID (GUID), Name (String), ISOCountryCode (String).

I have another table called "Outlet". It contains quite a bit more fields, but also has a field "ISOCountryCode".

What I want to do now, is to get a collection of Outlets from the country. The Country object has an IList for this, which should be populated by nHibernate.

Here is my current mapping, which isn't working:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="BS.SCP.Data.Country, BS.SCP.Data" table="Country">

<id name="m_ID" column="id" type="Guid" access="field">
<generator class="guid.comb"/>
</id>


<property name="ISOCountryCode"/>
<property name="Name"/>


<bag name="OutletList" table="Outlet" lazy="false" access="field.pascalcase-m-underscore">
<key column="ID" foreign-key="ISOCountryCode"/>
<one-to-many class="BS.SCP.Data.Outlet, BS.SCP.Data"/>
</bag>
</class>

</hibernate-mapping>

What am I doing wrong?

Kind regards, Marco...

This kind of collection mapping (FK column -> non-PK column) is not supported by NHibernate. Only mapping from FK to PK is supported, i.e. your Outlet table would have to contain field CountryID of type GUID.

Hi Sergey,

how would the "bag" look like if I used a field "CountryID" in Outlet instead of my ISOCountryCode? I tried something like this:

<bag name="OutletList" table="Outlet" lazy="false" access="field.pascalcase-m-underscore">
<key column="ID"/>
<many-to-many class="BS.SCP.Data.Outlet, BS.SCP.Data" column="CountryID"/>
</bag>

But my OutletList is always empty (it should contain two entries).

Regards, Marco...

Hi Marco,

here is my suggestion for your problem. It should go like this...


This assumes that the value of the column "CountryID" in table "Outlet" is equvivalent to the primary key value of the table "Country". Now it's a true PK->FK relationship. That means you will get all outlets to a selected country.

Greetings,
Chavez