I want to improve my code when deleting a group of objects in NHibernate (V3). Currently, I iterate over the resulting collection and call delete for each object. This generates n + 1 SQL statements.
I notice that the NHibernate session provides this method: Delete (string request)
Using this method, I think I can do the same with a single SQL statement.
Do you know if there is a way to combine this method with the QueryOver API to avoid HSQL?
fxkim source
share