Hey guys!
I have a composite element mapped like so:
Code:
<set name="EstimatedTargetCosts" table="AI_ESTIMATEDTARGETCOSTS">
<key column="ACTIVITYINSTANCE_ID" />
<composite-element class="PersistenceLayer.Entities.Maintenance.CompositeElements.TargetCost">
<property name="Amount" column="AMOUNT" />
<many-to-one name="Sort"
column="TARGETCOSTSORTID"
class="PersistenceLayer.Entities.Maintenance.TargetCostSort" />
</composite-element>
</set>
When the element that contains the "EstimatedTargetCosts" is loaded NHibernate performs a delete and insert on the AI_ESTIMATEDTARGETCOSTS table for each record that is loaded. This is a huge performance bust and not necessary since nothing is updated.
Can I tell the mapping to not do this? Would cascade be the option to use?
Thanks in advance for any kind of help.
Peter.