The POID should, as least, be unique in the same hierarchy.
Using TablePerClassHierarchy the PK is the same for the whole hierarchy that
mean you can't have {ID=1, Discriminato="A"} and {ID=1, Discriminato="B"}
so... the discriminator is unneeded.On Tue, Apr 12, 2011 at 10:29 AM, MattE <[email protected]>wrote: > I noticed in log file the following SQL for my > SalesInvoiceLine.Movements collection of SalesMovement objects > > NHibernate.Persister.Collection.AbstractCollectionPersister.LogStaticSQL(c: > \DotNet\NHibernate\NHibernateSource\nhibernate\src\NHibernate\Persister > \Collection\AbstractCollectionPersister.cs:572) - One-shot delete: > UPDATE Movement SET DocLineId = null WHERE DocLineId = ? > > This could reset more records than I was expecting as it does not > check the discriminator column, and the DocLineId holds Id's from > different tables. > > Have I missed an option or do I need nHibernate fixed or am I heading > down a path of pain with my design ? Needless to say I am stuck with > legacy database and can only make limited alterations. > > The product movement table holds PurchaseMovement and SalesMovement > records which link to Purchase Invoice lines and Sales Invoice lines, > stored in PInvLine and SInvLine tables. The DocLineId is the > InvoiceLineId from the applicable table so that SQL statement would > clear both if the same ID happened to exist in both PInvLine and > SinvLine table. The SalesInvoiceLine uses the following mapping:- > > HasMany<SalesMovement>(x => > > x.Movements).KeyColumn("DocLineId").Table("Movement").Cascade.SaveUpdate().AsSet(); > > Thanks > > Matt > > -- > 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. > > -- Fabio Maulo -- 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.
