I have a User
entity that contains the username, name and other non sensitive information.
During authentication, I need to query the password (hashed) and the password salt in order to do a hash comparison. Those two properties are not part of the model due to their sensitive nature.
How can I query those two properties in NHibernate without using CreateSQLQuery
? I now that CreateSQLQuery
works, but I was trying to find a non SQL way.