Bulk Updates and Deletes

Sarin · **Posted:** Thu Nov 10, 2005 8:26 am

NHibernate supports Bulk updates and Deletes? i could not find executeUpdate() method for query interface.
thanks in Advance
Sarin

roniburd · **Posted:** Thu Nov 10, 2005 11:13 am

Nhibernate does not currentyl support bulk update and delete. Remember it is ported from hibernate 2.1 and bulk operations appeared on version 3.x.

mteper · **Joined:** Wed Jun 08, 2005 4:59 pm **Posts:** 27

So how do people handle such cases now? I see there is a helper method for delete (with serious performance implications), is the "recommended" way to handle updates the same? I.e. if I need to perform a bulk update on a large number of records, my only option is to load 1 by 1, update and save?

thanks!
-MT

mnichols · **Joined:** Mon Aug 21, 2006 9:18 am **Posts:** 179

You may find help at http://www.ayende.com/Blog/2006/09/16/BatchingSupportInNHibernate.aspx.

mteper · **Joined:** Wed Jun 08, 2005 4:59 pm **Posts:** 27

I am not sure how that helps? I dont want to turn batching on outright and I dont see a way to do this for just one method. Besides, that is not the question I am asking. How did the Hibernate community hangle this prior to Hib3?

-MT

sergey · **Posted:** Mon Sep 18, 2006 1:38 am

You'll have to use ADO.NET to perform bulk operations.

mteper · **Joined:** Wed Jun 08, 2005 4:59 pm **Posts:** 27

sergey wrote:

You'll have to use ADO.NET to perform bulk operations.

Is there a way to have ADO.Net participate in the transaction?

Thanks!
-MT

sergey · **Posted:** Mon Sep 18, 2006 11:21 am

Yes, ITransaction.Enlist(IDbCommand).

basj · **Joined:** Sat May 14, 2005 2:17 pm **Posts:** 18

I think Batch operation are just checked in by Ayende. So you might try the trunc.

ps.
Is there a time frame for a non beta 1.2.0 version. It seems that the last stable is from january which is .net 1.1 only. It feels too long. I use the alpha with great succes and do not understand the reason for not releasing an official 1.0 version with generics support.