You could use something like:
[ActiveRecord("Game")]
class Game : ActiveRecordBase
{
[BelongsTo("BoardID")]
public Board OwnerBoard
{
get;
set;
}
}
[ActiveRecord("Board")]
class Board : ActiveRecordBase
{
}
Using one of the Find*(typeof(Game)) Methods you get an array of Games with
the correct OwnerBoard.
In this case you can simply bind Game.solveDate or Game.OwnerBoard.ID to the
datagrid, assuming
that the OwnerBoard never has a null value.
For viewing purposes you can also simply build a view with the necessary
properties and map it to a
new class:
[ActiveRecord("View_Game_Board")]
class ViewGame : ActiveRecordBase
{
}
or simply use ADO.NET to show the data and for editing purposes or something
like that load the entity
via FindByPrimaryKey...Board.FindByPrimaryKey(BoardID).
2010/5/11 Zvi Balas <[email protected]>
> 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]<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.
