CODEWITHSUNDEEP
fluent-nhibernate
Lucas Gazire
Lucas Gazire

Reputation: 311

Nhibernate Fluent Mapping multiple table to one object

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");

Upvotes: 0

Views: 48

Answers (1)

Lucas Gazire
Lucas Gazire

Reputation: 311

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();

Upvotes: 1

Related Questions