Hibernate Community • View topic - Sql query with custom types

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Sql query with custom types

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

dogcane

Post subject: Sql query with custom types

Posted: Fri Sep 26, 2008 6:00 am

Newbie

Joined: Fri Nov 10, 2006 4:42 am
Posts: 6

Hello, I'm trying to execute a sql query like this :

SELECT
Field1 AS {Component1.Field1},
Field2 AS {Component1.Field2},
Field3 AS {Field3}
FROM Table1

And in the code :

....
query.AddScalar("Component1", NHibernateUtils.Class);
query.AddScalar("Field3", NHibernateUtils.String);
query.SetResultTransformer(Transformers.AliasToBean(typeof(MYDTO)));
....

But the query doesn't operate the replace of "{...}".

Is it possbile to do a thing like this?

Thanks in advance.
Andrea

Top

whoami

Post subject: Re: Sql query with custom types

Posted: Fri Sep 26, 2008 8:39 am

Regular

Joined: Mon Aug 29, 2005 3:07 pm
Posts: 77

Yes, it is possible.
However, I'm not sure how you do it ?

You should make sure that your aliasses are exactly the same name as the properties of your 'DTO' object.
For instance:

Code:

class MyDTO
{
    public int Id {get;set;}
    public string Name {get;set}

    public MyDTO()
    {
       // public default constructor required
    }
}

Code:

ISQLQuery q = session.CreateSQLQuery ( "select EMP_Id AS Id, EMP_Name AS Name FROM tblEmployees" );
q.SetResultTransformer(Transformes.AliasToBean (typeof(MyDTO));

q.List<MyDTO>();

Top

pvradhakrishna

Post subject: query returns case insensitively with capital properties

Posted: Tue Oct 21, 2008 4:49 pm

Regular

Joined: Tue Feb 19, 2008 6:05 pm
Posts: 82

I see that my Oracle query is returning these Id and Name as ID and NAME respectively which are not found as properties in the class as they are case sensitive. Any suggestions?

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum