The following code snippet is from the following blog post:
http://www.javalobby.org/articles/hibernate-query-101/
for hibernate. I was wondering if there is something similar in
Nhibernate.
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Finally, I will present a variation on the previous technique, which
avoids the need to create a new data-transfer class for each query.
The idea is to retrieve a list of instances of a Hibernate-persisted
business class, using a given HQL query, but with only a specified set
of columns being instantiated. This allows fast, light-weight queries
which return only the minimum necessary information, and avoid complex
joins in the HQL queries. For example :
String query =
"select com.id, com.label, com.postCode, com.mayor.name
from Community as com
left join com.mayor
order by com.label ";
results = HibernateUtils.find(query);
This query will return a list of Community objects, but with only the
4 specified fields instantiated. Note that this is a powerful
technique, as the presentation layer may use ordinary business classes
instead of data transfer objects, without having to know the details
of the querying techniques being used. T
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Thanks,
Vikram
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
