Hi,

Is it possible to make an arbitrary query against a database, whose columns returned from the query do not map to any particular domain object?

Or should I just drop out to ADO.NET for this?

Thanks,

Adam

If you are using Hibernate 3, the you could potential use a HQL like:

select new Name(per.First_Name,per.last_name) from Person

If you don't specify the "new Name" then you'll get an Object[] []containing the values.

yes, it is possible with NHibernate as well.

cheers,
Radu

Hi,

So if I use the new syntax as you describe above,

Do I need a Name class that Nhibernate knows about (eg has some mapping file associated with it), or can it just be a standard c# class?

Thanks,

Adam

No, you don't. I have used HQL to return a list of strings that I used to populate a dropdown list. You can't use HQL for a completely arbitrary query, you can only select properties of already mapped objects.

cheers,
Radu