Hi all

i have 2 entities

Parent and Child  in TPT Inheritance ( Table per Type Inheritance ) mapped
by joined-subclass

when i tried to do that :

Session.CreateQuery(string.Format("Delete From Child").ExecuteUpdate();

i get this error :

could not insert/select ids for bulk delete[SQL: insert into #[dbo].[Child]
SELECT childx0_.[Id] as [Id] FROM [dbo].[Child] childx0_ inner join
[dbo].[Parent] childx0_1_ on childx0_.[Id]=childx0_1_.[Id]]

I get this as inner exception : {"Incorrect syntax near 'dbo'."}

this is mapping :

  <class name="Parent" table="[dbo].[Parent]" lazy="true"  >
    <id name="Id" column="[Id]" type="Int32">
    <joined-subclass name="Child" table="[dbo].[Child]" lazy="true" >
      <key>
        <column name="[Id]" />
      </key>
      <property name="Text" column="[Text]" type="String" not-null="true"
/>
    </joined-subclass>
  </class>

-- 
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.

Reply via email to