Hello there,
I'm trying to create a light entity consisting of several properties
of multiple table, as described in the following discussion:
http://groups.google.com/group/nhusers/browse_thread/thread/38e7ebc04d6c219a/8965bd254c19bc96?lnk=gst&q=join+table#8965bd254c19bc96
Now, the thing is that I wish to use a join on the two tables, so that
when doing massive reading from the database, the less data that'll be
read, the faster will the query will go, which is why I prefer not to
use the solution suggested in the aforementioned discussion.
I would like to know whether a <Join Table="MyTable"> could be used
with specifying the join column on the primary entity/table. From what
I've seen, the join takes the ID column. The only way I found to do
this was to declare the foreign key column as the ID of the primary
table (if to use the example given in that discussion it'll be:
<class name="Car">
<id name ="EngineID"> <--obviously not good-->
...
<join table="Engines">
<key column="ID"/>
<property name="NumberOfCylinders" column="NumCylinders"/>
</join>
This, obviously, is not the way to go, but it pretty well illustrates
what I wish to do.)
Any ideas and comments would be highly appreciated!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
