Value cannot be null. Parameter name: fieldName error in NHibernate formula

Im currently using Hibernate with Spring in Java. Now I know you are using asp.net but the basic concepts should be the same.

The hibernate queries I use reference a class, and we have hibernate mapping (xml) files that map variables inside a class to a column in the table

It looks like you got normal sql, I wonder if you need to use it as Hibernate expects?

I do not use formula's like you do as Ive coded it with the class querying. XML files simply used to map (*.hbm.xml)

Hi Nidhi,
As far as I've read formulas have to be sql, hql won't work there.
But I figured out what the problem was. In this particular case I had created a sql query instead of using the hql, in order to get a particular result set of the user class that this formula is part of. So the sql was not adding the AnswersCount "virtual" property and that was why it was giving an error.