Dynamic Instantiation w/Native SQL Queries

tylord · **Posted:** Thu Aug 18, 2005 5:31 pm

Is it possible to use Dynamic Instantiation in native sql queries?

In hql, you can do this:

Code:

select new SomeObject(persitentObj.Id, persitentObj.Name) from PersistentClass persitentObj where...

Is there a sql query parallel, or is it something obvious that I'm not seeing?

KPixel · **Posted:** Fri Aug 19, 2005 9:19 am

AFAIK, it is not possible in native SQL.

k-dub · **Joined:** Thu May 12, 2005 8:45 am **Posts:** 226

I must be confused, as this looks pretty straight forward.

SQL:

Code:

select t.ID, t.NAME from Table t where .....

App Code:

Code:

ArrayList foo = new ArrayList();
... get DataReader from Command and loop through it ...
foo.Add( new SomeObject( reader["ID"], reader["NAME"] ) );
... close connection ...

Now 'foo' is a collection of your custom object. This should be very similar to what NHibernate would do internally. Since NH can do it, it must be possible.