Hi,
I have many-to-one for User and Position and when I want to load the
users it makes one select to get all the users and then one select per
user to get the position for each one.
Is there any way to avoid this and actually load everything with one
select?
Thank you
----
IList<User> items = session.CreateQuery("from User").List<User>();
---
<class name="User" table="User" >
<id name="Id" column="id">
<generator class="native" />
</id>
<property name="Name" column="name" />
<property name="Year" column="year" />
<many-to-one name="RealPosition"
class="Position"
column="position_id" />
</class>
----
<class name="Position" table="Position" >
<id name="Id" column="id">
<generator class="native" />
</id>
<property name="Name" column="name" />
</class>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
