Nhibernate Fluent Mapping multiple table to one object

Question

I have 3 tables that represents a many to many mapping. Two tables with different ids and a third table with a composite key referencing the other two.

How can i map this using the classmap in nhibernate?

The following doesn´t work:

HasManyToMany(m =>
                    m.ListBlockStatus)
                    .Table("BlockTypeAction")
                    .ParentKeyColumn("IdBlockActionDefinition")
                    .ChildKeyColumn("IdBlockTypeCategory")
                    .Table("BlockTypeCategory")
                    .ParentKeyColumn("Id");

Lucas Gazire · Accepted Answer · 2017-08-09 18:24:25Z

1

Found what i need, unfortunately the query in the end is not an inner join.

            HasManyToMany(m => m.ListBlockStatus)
            .Table("BlockTypeAction")
            .ChildKeyColumns.Add("IdBlockActionDefinition")
            .ParentKeyColumn("IdBlockTypeCategory")
            .Cascade.All();

answered Aug 9, 2017 at 18:24

Lucas Gazire

3115 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Nhibernate Fluent Mapping multiple table to one object

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