A new error now ---> NHibernate.MappingException: collection foreign key mapping has wrong number of columns: SR.Domain.Client.Entities.Client.AccountTypeHistory type: Int32
On Mar 16, 12:33 pm, epitka <[email protected]> wrote: > Figured it out, was missing property-ref in key. > > On Mar 16, 11:54 am, epitka <[email protected]> wrote: > > > Hi, I am trying to map a collection (bag) or items that have composite > > id. The mapping I have throws an error saying that > > > NHibernate.FKUnmatchingColumnsException: Foreign key > > (FK6A7D859A4C8DCC7F:ClientAcctType [ClientId, EffectiveDate])) must > > have same number of columns as the referenced primary key (Client > > [ClientId]) > > > I have a Client and ClientAcctType tables where ClientAcctType is > > basically a history table. So I want to map this history for specific > > Client. I created a ClientAccountTypeCompositeID class and mapped the > > history item like this > > > ClientAcctountTypeHistoryItem: > > <composite-id class="ClientAccountTypeCompositeID" > > name="Id" access="lowercase-underscore"> > > <key-property name="ClientID" access="property" > > column="ClientId"/> > > <key-property name="EffectiveDate" access="property" > > column="EffDt" /> > > </composite-id> > > > Client: > > <bag name="AccountTypeHistory" lazy="true"> > > <key> > > <!-- a collection inherits the composite key type --> > > <column name="ClientId"/> > > <column name="EffectiveDate"/> > > </key> > > <one-to-many class="ClientAccountTypeHistoryItem"/> > > </bag> > > > This should be pretty straight forward. Where I am going wrong? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
