Using NHibernate just to convert to native SQL

ryanpudd · **Posted:** Wed Feb 18, 2009 7:22 am

Hi,
Sorry if this is a waste of time, but I wanted to know if its possible to use NHibernate to convert from HQL to the native SQL without having to persist the data in classes.

I have an application which needs to connect to both Oracle and MSSQL servers and would prefer not to have to write two seperate queries for each

Thanks

Ryan

ryanpudd · **Posted:** Mon Feb 23, 2009 10:34 am

Is this too obvious a question? I really need to know a simple yes or no as to whether it supports it?

If it does a URL to get me started and I'll be happy to work from there

Thanks

Ryan

michal · **Posted:** Mon Mar 02, 2009 4:38 am

It depends what you mean by "persist the data in classes" .

You need to write classes and mappings to use HQL.

You can return non-persistable objects from HQL queries (projection queries) - as array of object() or array of DTO objects (select new DTOObject1(obj.col1,obj.col2 , ...) ....

ryanpudd · **Posted:** Mon Mar 02, 2009 6:17 am

michal,
Thanks for the reply.

Basically I want to use NHibernate to query a database using HQL and just return the data. I do not want a class for each table

Is this possible? Or is there something else that is suitable?

Thanks

Ryan

michal · **Posted:** Mon Mar 02, 2009 6:36 am

As far I know you need the classes.

Take a look at My Generation project, it can help to automate the process of classes/mappings creation http://www.mygenerationsoftware.com.