Since we are talking about OR/M, a join between two tables usally represents
a collection property
of an root entity. So may an Order Entity have a collection of OrderItems
Entities, the RDMS specifics
are in the mapping of those classes.
[ActiveRecord("TBL_ORDER")]
class Order
{
[HasMany(typeof(OrderItem), Table="TBL_ORDERITEM", ColumnKey="ORDER_ID")]
public IList OrderItems
..
}
So the list of OrderItems can simply retrieved using
IList pItems = pOrderEntity.OrderItems;
Beside this there are several ways for querys:
- FindbyPrimaryKey
- FindAll
- FindFirst
- SimplyQuery
- ScalarQuery
- ICriteria
etc.
I don't know if this answers your question, since all of this is good
described in the documentation.
Regards
2010/5/10 Zvi Balas <[email protected]>
> Hi all,
> i'm new to AR,
>
> I created two table with relation of HasMany between them
> Now, i want to make a simple fetch that return me s list collection of
> a join operation between the tables.
>
> Can anyone assist me with it?
>
> i tried to find help in the documentation/google with no luck.
> please help me with examples or any other references.
>
> Thanks
> Zvi
>
> --
> You received this message because you are subscribed to the Google Groups
> "Castle Project Users" group.
> To post to this group, send email to [email protected]
> .
> To unsubscribe from this group, send email to
> [email protected]<castle-project-users%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/castle-project-users?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"Castle Project Users" 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/castle-project-users?hl=en.
