Thanks, but this is not exactly what i'm looking for. suppose we have two table: Board: int ID string Name int BoardSize
game: int ID int BoardID string solveDate BoardID is ID of table Board. i have many entries in game that link to the same Board. i want to make a join that will return me a list with the following fields: gameID, BoardID, Name, BoardSize, SolveDate i'm planning to take this list and put it in a wpf datagrid fot the user to see. Can you assist me with this join operation? Thanks, Zvi On Tue, May 11, 2010 at 2:44 AM, Belvasis <[email protected]>wrote: > 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]<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.
