Greetings,

If someone can give me examples of the three session.Delete overloads (the session.Delete(obj) I understand easy enough :-)

Delete(string query, object value, IType type)

Delete(string query)

My scenario is this - I need to delete a user and all I have is that user's unique identifier. I want to delete the user without having to load the user object.

Please advise.

NHibernate usually needs to load the deleted object to handle cascades and similar stuff. But if you have proxies enabled, you might get away with:

But maybe Delete will still initialize the proxy, I'm not sure. Delete with the query argument executes the query, and deletes the objects returned. The value and type arguments are used to pass a parameter to the query.

Could you provide 2 examples of using the .Delete with the query and the value and type arguments? I can not figure out the IType..


I try things such as .Delete("from assembly.Customer cst where cst._id = {0}", crit.ID, NHibernate.Type.GuidType); etc and get all sorts of errors.

I need some specific examples please.

Untested, but try this:

NHibernate.Type.GuidType is a class, you need an instance, and NHibernateUtil contains static instances of all types. Also, parameters are specified using question marks.

Thanks much - checked the docs, looked for hibernate examples, looked at the code - could not find anything anywhere.

Your time is much appreciated - now off to test this solution out :-)