ISession.Delete() got 3 overloads that I could not find in Documentation on how to use it. The one I can use now is Isession.Delete(object obj) which I have to load object from db first before delete it. That is not a fast way to delete Entity.

Is there a way to delete entities by column name and value? (without having to write native SQL.)

Thanks

There isn't any such way in NHibernate currently. The object has to be loaded to process cascades and potential lifecycle callbacks.

I think you can use named query for such deletes