cascade to all will remove them all, only if you delete the root entity. if you want the collection items to be removed, while the root entity remains, it needs to be all-delete-orphans.
hope that helps 2009/4/6 Vels <[email protected]> > > i changed cascade="all" ... but still same problem > > <bag name="MasterItemList" table="tblCategorisedItems" > cascade="all" > collection-type="Collection.ObservableList`1 > [[emPowerBO.MasterItem, emPowerBO]], Collection"> > <key column="CategoryCode"/> > <many-to-many column="MasterItemCode" > class="emPowerBO.MasterItem,emPowerBO"/> > </bag> > > > > On Apr 6, 5:19 pm, James Crowley <[email protected]> wrote: > > You might want to check your cascade options? If you want orphaned > entities > > to be removed, you need to set it to all-delete-orphans... but make sure > you > > understand the implcations of this. > > > > Seehttp:// > ayende.com/Blog/archive/2006/12/02/NHibernateCascadesTheDiffer... > > more info. > > > > Hope that helps > > > > James > > > > 2009/4/6 Vels <[email protected]> > > > > > > > > > > > > > Hi... > > > > > I am working with VB.Net 2008, SQL 2005, NH2.0.1 > > > > > followings are my mapping information: > > > > > <?xml version="1.0" encoding="utf-8" ?> > > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > > > namespace="emPowerBO" assembly="emPowerBO" > > > schema="emPowerMasterV4.dbo"> > > > <class name="MasterCategory" proxy="MasterCategory" > > > table="tblCategories" lazy="true" > > > discriminator-value="MasterCategory"> > > > <id name="CategoryCode" column="CategoryCode" type="Int64" unsaved- > > > value="0"> > > > <generator class="native"/> > > > </id> > > > <property column="CategoryName" type="string" name="CategoryName" > > > not-null="true" length="255"/> > > > > > <bag name="MasterItemList" table="tblCategorisedItems" > > > cascade="none" > > > collection-type="Collection.ObservableList`1 > > > [[emPowerBO.MasterItem, emPowerBO]], Collection"> > > > <key column="CategoryCode"/> > > > <many-to-many column="MasterItemCode" > > > class="emPowerBO.MasterItem,emPowerBO"/> > > > </bag> > > > > > </class> > > > </hibernate-mapping> > > > > > test 1 :MasterItemList.add(Masteritem1) > > > :session.update(MasterCategory) > > > :trans.Commit() > > > works fine :) Masteritem1 added to my collection and table > > > too > > > > > test 2 :MasterItemList.add(Masteritem2) > > > :session.update(MasterCategory) > > > :trans.Commit() > > > :Masteritem2 added to my collection and table too > > > > > :MasterItemList.Remove(Masteritem1) > > > :session.update(MasterCategory) > > > :trans.Commit() > > > :Masteritem1 removed from my collection but not deleted from > > > my table > > > > > test 3 :MasterItemList.remove(Masteritem1) > > > :session.update(MasterCategory) > > > :trans.Commit() > > > : works fine :) Masteritem1 removed from my collection and > > > from table too > > > > > :MasterItemList.Remove(Masteritem2) > > > :session.update(MasterCategory) > > > :trans.Commit() > > > :not working :( Masteritem2 removed from my collection but > > > not from table > > > > > what could be the mistake ? > > > is my mapping informations correct ?- Hide quoted text - > > > > - Show quoted text - > > > -- James Crowley Managing Director Developer Fusion - Connecting developers worldwide Developer Fusion Ltd | 58 Sandringham Close | Enfield, EN1 3JH mob: 07986 624128 web: http://www.developerfusion.com/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
