or Create a profile

Home → Help and guidance →

Weird issue with Many-To-Manys

Tommy's Avatar

Tommy

23 Jul, 2010 11:26 AM via web

Hello all,

I'm coming across a weird issue with Many-To-Manys when using Fluent NHibernate with Automapping.

I have two classes, a User and a Campaign. Both have an IList of the other type to form a Many-To-Many.

On my local machine this works fine with the DataBase creating the table "UsersToCampaigns". I've copied the code and the database up to a UAT environment but none of my Campaigns are found for a User. When checking the database on the UAT site I've now found that it is disregarding the "UsersToCampaigns" table and has created it's own "CampaignsToUsers" table...

This all seems very odd to me; I assumed there would be a system about which table is created and used when using Many-To-Many? And how could it possibly go wrong using the same code and DB?

Thanks in advance,

Tommy

  1. Support Staff 2 Posted by Paul Batum on 25 Jul, 2010 08:56 AM

    Paul Batum's Avatar

    This used to be a recurring issue but I thought it was resolved when some
    sorting code was added for when we load types from an assembly. Are you
    using the latest version of FNH?

Reply to this discussion

Preview Comments are parsed with Markdown. Help with syntax

Attached Files

    You can attach files up to 10MB

    What is the number before twelve?

    2 people watching.

    • New Issue

    • Conversation Started

      The Fluent NHibernate staff has started a conversation to resolve this discussion.

    • Close the discussion

    Recent Discussions

    09 Dec, 2010 09:42 AM Property formula is not working.
    08 Dec, 2010 05:24 PM Setting length on composite -key property
    02 Dec, 2010 09:33 PM Setting Component as Unique Key
    02 Dec, 2010 07:29 PM Conventions for ICompositeUserTypes and field overrides
    26 Nov, 2010 01:24 PM Maping details collection using interface for detail

     

    22 Nov, 2010 09:59 PM Mapping a view without a unique id column
    22 Nov, 2010 09:27 PM <many-to-one> and access setting
    18 Nov, 2010 03:32 PM Control the name of the Primary Key and Unique Constraint Names
    18 Nov, 2010 03:00 PM ForeignKeyConstraintName for References
    14 Nov, 2010 12:40 PM SQLite Versioning Configuration Question