Problem1:
I have a project where NHib creates the database from mapping file. The problem is that I want to add a ForeignKey without defining any set, map, list or bag. Only foreign key without any mapping.

For example: I have [Warehouse] table and [Transfer] table. I transfer products from one warehouse to another. In [Transfer] I have two columns call [Warehouse_From] and [Warehouse_To]. How can I define in mapping file two ForeignKeys to the parent table [Warehouse]?

Problem2:
Is it possible this kind of relation and how to define it in NHib. I have [Parent] table and [Child] table. I need a foreign key and in the child class I have IList for example.

Hi mynkow,

have two fields in your Transfer class and map them both <many-to-one> to the Warehouse class.

There is no need that the Warehouse class has any knowledge about that.

CU
Froestel

Will this mapping create a foreign key constraint in the database?

PS: I am not able to test it today.

Hi mynkow,



Two, actually. (If you use a DB that supports FKs.)

CU
Froestel

How can I specify the foreign key name?

Hi mynkow,

RTFM: Many-to-one.

CU
Froestel

Hi Froestel,

I want to avoid mapping with bag, list, set or any of those. I want to create a mapping file and define a foreign key constraint within that file for some columns without creating any collections in my classes.

Hi mynkow,

so just do what I posted above. There's no collection involved. This simply associates the two fields of type Warehouse in your Transfer class with the Warehouse class for Hibernate. This way Hibernate can tell which items are related to a certain Transfer instance. Hibernate will do that by creating two FKs pointing from the table that keeps the Transfer instances to the table that holds the Warehouse instances.

CU
Froestel

I want to create a mapping file and define a foreign key constraint within that file for some columns without creating any collections.