This code:

session.Delete("FROM Foo f WHERE f.BooId = ?", 10, NHibernate.NHibernateUtil.Int32);

Generates SQL:

SELECT FROM ....

not

DELETE FROM ....

Is this a bug or have I missunderstod this delete method?

Hibernate version: 1.2.0.GA

I believe the Delete method makes persistent objects transient objects, and when a flush occurs will remove the item from the database. I believe that when you pass HQL to a delete method it needs to first load the objects you want to delete, and then later gets deleted with the flush command. This then can ensure proper handling within NHibernate, such as cascade="delete".