Delete multiple objects in NHibernate 3.2

Question

In my Repository I have a method like this:

public int Delete(Expression<Func<TEntity, bool>> predicate) {
    var listToDelete = UnitOfWork.Session.Query<TEntity>().Where(predicate).ToList();
    foreach(var item in listToDelete)
        UnitOfWork.Session.Delete(item);
    return listToDelete.Count;
}

But it seems this method has not a good performance! Have you any suggestion for delete a list of objects (by a predicate) in NHibernate 3.2 please?

score 2 · Answer 1 · answered Mar 07 '12 at 06:19

2

Use IStatelessSession to delete or update multiple objects. It will be faster because the identity map will not slow down the session/operations.

You can also use HQL queries for batch operations.

answered Mar 07 '12 at 06:19

Dmitry S.

8,373
2
39
49

I'm new to NHibernate; can you show me an example please? Thanks – amiry jd Mar 07 '12 at 10:49
Stateless session: http://nhforge.org/blogs/nhibernate/archive/2008/10/30/bulk-data-operations-with-nhibernate-s-stateless-sessions.aspx – Dmitry S. Mar 07 '12 at 17:09

Delete multiple objects in NHibernate 3.2

1 Answers1