Mapping using an intermediate join table with 2 primary keys

Question

How can I fluently map 2 entities that are joined together using a "join" table (it has 2 primary keys).

My entities:

Users
Roles

Then the 'join' table looks like:

RolesUsers
  RoleId
  UserId

So I want to query like this:

user.Roles

Cole W · Accepted Answer · 2011-10-17 15:14:18Z

1

In Fluent NHibernate this is achieved by using HasManyToMany in your mapping. Ex: (User mapping)

 HasManyToMany(x => x.Roles)
                .Table("RolesUsers")
                .ParentKeyColumn("UserId")
                .ChildKeyColumn("RoleId")
                .Cascade.All()
                .Inverse()

answered Oct 17, 2011 at 15:14

Cole W

15.4k7 gold badges56 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mapping using an intermediate join table with 2 primary keys

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related