Query regarding the Nhibernate many to many mapping

Posted by Pramod on Stack Overflow See other posts from Stack Overflow or by Pramod
Published on 2010-05-14T06:15:43Z Indexed on 2010/05/14 6:24 UTC
Read the original article Hit count: 292

Filed under:

nhibernate-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 posts about nhibernate-mapping

Nhibernate mapping

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All I am trying to map Users to each other. The senario is that users can have buddies, so it links to itself I was thinking of this public class User { public virtual Guid Id { get; set; } public virtual string FirstName { get; set; } public virtual string LastName… >>> More
Need help with NHibernate / Fluent NHibernate mapping

as seen on Stack Overflow - Search for 'Stack Overflow'
Let's say your have the following table structure: ============================== | Case | ============================== | Id | int | | ReferralType | varchar(10) | … >>> More
Mapping a collection of enums with NHibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
Mapping a collection of enums with NHibernate Specifically, using Attributes for the mappings. Currently I have this working mapping the collection as type Int32 and NH seems to take care of it, but it's not exactly ideal. The error I receive is "Unable to determine type" when trying to map the… >>> More
Multiple tables\objects in one nHibernate mapping

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Folks I am trying to create an nHibernate mapping for a class structure like so: class UserDetails{ Guid id; User user; Role role; public User UserInfo{ get;set; } public Role UserRoles{ get;set; } public Guid ID{ Get; set; } } class… >>> More
(Fluent)NHibernate: Mapping an IDictionary<MappedClass, MyEnum>

as seen on Stack Overflow - Search for 'Stack Overflow'
I've found a number of posts about this but none seem to help me directly. Also there seems to be confusion about solutions working or not working during different stages of FluentNHibernate's development. I have the following classes: public class MappedClass { ... } public enum MyEnum { … >>> More

Developer IT