Hi,

I wondered if I could create an sql query with hibernate that does not map to an object.

For example I have a view VW_Person and I want the Hoursworked column of a person.
So my query is "select Hoursworked from VW_Person where Person.ID = 1" or something like that.

Now can I do this

Session.CreateSqlQuery(query, "Hoursworked", typeof(decimal));

anybody who can help me ?

The error I get with this is

Unknown entity class: System.Decimal

Are you sure CreateSqlQuery works for scalar values?

The error you get means that it is expecting a persistant class to be returned.

Check http://www.hibernate.org/hib_docs/nhibernate/html_single/ section 13.

I'm not sure that Hibernate can work with scalar values.

I just need something like that, the problem is like this

I'm working with an Hibernate Session in an test environment.

so I create all my entities, but nothing get realy saved to the database as long as I do not commit the session. The reason for this is that at teardown of the test all the values will automatically will be removed without any worry that something has left behind in the database.

Now I've got my Person in my Hibernate Session and the view contains the performed hours of that person. So as i want to get my view with an sqlconnection, the connection does not see any data in the database.

Thats why I wondered if Hibernate was not able to work with scalar values.