many-to-many with extra columns nhibernate

by

The many-to-many, without the explicit mapping of the pairing table as an entity – is in NHibernate of course suported. So, in case, that the Date column is autogenerated, or nullable (does not have to be inserted by app/NHiberante), we can do it like here: 6.8. Bidirectional Associations

<class name="User">
    <id name="Id" column="Uid"/>
    ...
    <bag name="Groups" table="UGlink" lazy="true">
        <key column="Uid"/>
        <many-to-many class="Group" column="Gid"/>
    </bag>
</class>

<class name="Group">
    <id name="id" column="Gid"/>
    ...

    <!-- inverse end -->
    <bag name="Users" table="UGlink" inverse="true" lazy="true">
        <key column="Gid"/>
        <many-to-many class="User" column="Uid"/>
    </bag>
</class>

So, what we have is a mapping, in which NHiberante does care about the pairing table, and we can do:

thisUser.Groups

But if I could suggest, do not go with many-to-many. The many-to-one with pairing object is (I’d say) better solution, because it will support searching Users by Groups and vice versa.

See Chapter 24. Best Practices, cite:

Don’t use exotic association mappings.

Good usecases for a real many-to-many associations are rare. Most of the time you need additional information stored in the “link table”. In this case, it is much better to use two one-to-many associations to an intermediate link class. In fact, we think that most associations are one-to-many and many-to-one, you should be careful when using any other association style and ask yourself if it is really neccessary.

Here is some more detailed explanation how to do it without many-to-many: Nhibernate: How to represent Many-To-Many relationships with One-to-Many relationships?

More Related Contents:

  1. Query on HasMany reference
  2. Generic Repository or Specific Repository for each entity?
  3. NHibernate AliasToBean transformer associations
  4. NHibernate QueryOver with Fetch resulting multiple sql queries and db hits
  5. Minimal and correct way to map one-to-many with NHibernate
  6. Persist Data by Programming Against Interface
  7. Identifying NHibernate proxy classes
  8. Should I transform Entity (Persistent) objects to DTO objects?
  9. NHibernate How do I query against an IList property?
  10. How to tell Fluent NHibernate not to map a class property
  11. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  12. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  13. NHibernate – Many to Many Query using Junction/Joiner Table
  14. How to create NHibernate HasManyToMany relation
  15. How does TransactionScope roll back transactions?
  16. How to partially project a child object with many fields in nHibernate
  17. Best way to save a ordered List to the Database while keeping the ordering
  18. Fluent NHibernate, working with interfaces
  19. NHibernate.MappingException: No persister for: XYZ
  20. Problem using SQLite :memory: with NHibernate
  21. Best way to convert IList or IEnumerable to Array
  22. Programming to interfaces while mapping with Fluent NHibernate
  23. How to find the most recent file in a directory using .NET, and without looping?
  24. Interface or abstract class?
  25. Virtual webcam input as byte stream
  26. How to create a custom MessageBox?
  27. Can I turn off impersonation just in a couple instances
  28. A pattern to pause/resume an async task?
  29. External Terminal / Debug outside the IDE
  30. Setting Button FlatStyle in WPF

Leave a Comment