Is there any way to 'Fast' Delete an Entity?

gatapia · **Joined:** Sat Jun 11, 2005 1:56 am **Posts:** 19

Hi All,

I have a very slow loading Entity (has a large blob). I want to:

Code:

session.Delete("FROM EntityName WHERE EntityNameID = X");

Without it actually loading the entity first. The entity is not related to anything as is clear through the hbm.xml file. Well I know its not that clear. Here is the hbm.

Code:

<?xml version="1.0" encoding="utf-8" ?> 
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
   <class name="DAL.AttachmentContent, DAL" table="`AttachmentContent`">
      <jcs-cache usage="read-write"/>      
      <id name="ID" column="`AttachmentContentID`" unsaved-value="0"><generator class="native"/></id>      
      <property name="Contents" column="`Contents`" type="Byte[](16000000)" length="16000000" not-null="true"/>
   </class>
</hibernate-mapping>

Is there anyway I can force NH to just run a delete query rather than load the entity then delete it?

Cheers

Guido Tapia

PS: Congrats on all the great news about NH lately, awesome product.

Ayende Rahien · **Joined:** Sat Sep 24, 2005 11:25 am **Posts:** 198

I don't think so.
I thought it was stupid until I considered the case of mapped associations and cascades, that NHib needs to handle as well.
If you want to do a big delete, just write the SQL to do it.

DELETE FROM [Entity] WHERE [EntityNameID]=@id;

k-dub · **Joined:** Thu May 12, 2005 8:45 am **Posts:** 226

I think this might be a handy thing to have, even if Hibernate doesn't have it. Something like:

Code:

ISession.Delete( Type type, int id );

max · **Posted:** Mon Nov 28, 2005 5:21 pm

that would be the same as Session.Delete(Session.Load(type, id)); would it not ? ;)

delete without handling cascades is what hibernate 3.0/3.1 has added via DML support. ?

k-dub · **Joined:** Thu May 12, 2005 8:45 am **Posts:** 226

max wrote:

that would be the same as Session.Delete(Session.Load(type, id)); would it not ? ;)

No, the point is to delete without loading first, so it would do just that.

max · **Posted:** Tue Nov 29, 2005 2:30 am

so that would be:

s.createQuery("delete type where id = :id").seParameter(42).executeUpdate();

adding a delete operation on Session that does not obey delete cascade semantics doesn't sound consistent to me.