tags:

views:

19

answers:

0
+1  Q: 

Query regarding the Nhibernate many to many mapping

Hi, I have a requirement where i have 3 dimension tables (employee, project, technology) and a common fact table which has the key id's of all these three tables.

My question goes like this...

How do i create a mapping table (fact table) having these three columns - emp_id, proj_i and tech_i. I know we can achieve this for two tables using the below syntax:

HasManyToMany(x => x.Empl) .Table("Emp_Proj") .ParentKeyColumn("Emp_i") .ChildKeyColumn("Proj_I") .Inverse() .Cascade.All();

How can i add another child key column (tech_i) to the above mapping table?

related questions

NHibernate: how to enable lazy loading on one-to-one mapping
NHibernate mapping - one-to-one (or one-to-zero)
NHibernate child to polymorphic parent mapping
How to map to get value from primary table in Nhibernate?
How can i view the mapping configurations passed to the NHibernate by the castle activerecord?
Could we have custom name of the primary key column in Fluent NHibernate?
Using Additional Data on Intermediate Table with NHibernate
Storing a comma separated list in a field using nHibernate
Normalizing EnumStringType in NHibernate
NHibernate mapping with a class hierarchy whose base class is abstract and the discriminator is not a string
Can this mapping be done with (Fluent) NHibernate?
Nhibernate ValueType Collection as delimited string in DB
NHibernate Many-to-many
NHibernate: Best way to deal with intermediary table using Fluent NHibernate?
NHibernate Inheritance mapping when sub class in Separate Assemblly
Fluent NHibernate: How to create one-to-many bidirectional mapping?
NHibernate - Is there any good tools to assist you with the configuration file?
Mapping a class with multiple collection properties containing the same object type
Joining NHibernate Classes that share a common column but no foreign key
Fluent NHibernate - how to map a subclass one-to-one?
NHibernate many-to-one and unique constraint violation
NHibernate: One base class, several mappings
Is there any way to fake an ID column in NHibernate?
NHibernate: How can I combine fields from two classes?
Mapping a collection of enums with NHibernate