title: NHibernate - cascade delete is not working
body: <p>I use NHibernate 3.2 with MS SQL Server 2008 R2</p>
  
  <p>I have the fallowing mappings</p>
  
  <pre><code>&lt;class name="LocalizedProperty" table="LocalizedProperty"&gt;
     &lt;cache usage="read-write"/&gt;
     &lt;id name="Id" column="Id"&gt;
        &lt;generator class="guid.comb"/&gt;
     &lt;/id&gt;
     &lt;property name="CultureName"  not-null="true"/&gt;
     &lt;property name="PropertyName"  not-null="true"/&gt;
     &lt;property name="PropertyValue"  not-null="true"/&gt;
  
     &lt;any id-type="Guid" name="Entity"&gt;
        &lt;column name="LocalizedEntityClass"  not-null="true"/&gt;
        &lt;column name="EntityId"  not-null="true"/&gt;
     &lt;/any&gt;
  &lt;/class&gt;
  </code></pre>
  
  <p>And this one has a Reference to LocalizedProperty:</p>
  
  <pre><code>&lt;class name="CommunicationType" table="CommunicationType" lazy="false"  &gt;
  ...
  &lt;set name="LocalizedProperties" where="LocalizedEntityClass = 'Prayon.Entities.CommunicationType'" cascade="delete"&gt;
    &lt;key column="EntityId" foreign-key="none" /&gt;
    &lt;one-to-many class="LocalizedProperty" /&gt;
  &lt;/set&gt;
  &lt;/class&gt;
  </code></pre>
  
  <p>My Problem is, when I delete an entity of CommunicationType, NHibernate is executing the fallowing update-statement for LocalizedProperty</p>
  
  <pre><code>UPDATE LocalizedProperty SET EntityId = null WHERE EntityId = @p0 AND (LocalizedEntityClass = 'Prayon.Entities.CommunicationType')
  </code></pre>
  
  <p>Instead of a Delete-Statement.</p>
  
  <p>Does someone see, what is wrong?</p>