I'm trying to get a user by it's username and password. Nothing advance. When I try to do this NHibernate starts complaining about me not returning all fields, they're null.

Refer to: http://forum.hibernate.org/viewtopic.ph ... procedures

Which is the same problem as mine. Can I somehow return my user object with only the username and password instead of all fields, many-to-one and such? I've tried, not-null="false". It needs a bit more performance if it need to load all the fields instead one two. And my stored procedures are way to big for it's purpose.

Anyone have any ideas? :(

EDIT:
I should use scalar queries right? Now, how do I extract them from my result?