Is there a way to do a fast delete? One where nhibernate knows not to load the objects first? I'd like nhibernate to empty its cache and and trust me that my call to truncate a large audit table does not affect dependancies. I'd love to keep my O-R languange and not have to revert to a SQL snippet.

I think the answer is a firm NO...but I had to ask as I have a delete that is taking 2 minutes plus.

I haven't tried this, but I wonder if it would be possible to create an object of AuditDelete and a mapping with the audit date as the key field.

Then create the Audit Delete object and populate the id field with the audit date that you want to delete. Then delete this object.

The SQL generate should be:

DELETE FROM AuditTable WHERE AuditDate = @date

This will delete all the audit records from that date. You will still need to send a statement for each date, but it should be faster than one for each audit record.

BOb

Like the idea unfortunately the date is a date time (with seconds) so it would'nt work for my situation.[/i]

I think this is one of the features that Hibernate 3.0 has. It would be nice to have it in NHibernate as well :D