Relations with more than one entity in between? : I believe this should work (in...

Sat, 20 Sep 2008 12:14:54 -700

Author: GregD
Subject: 943
Posted: 20-Sep-2008 at 12:14pm

I believe this should work (in the Household class):

    public EntityList TicketSales {
      get {
        PersistenceManager pm = this.PersistenceManager;
        EntityList lineItems =
          pm.GetChildren(this.Transactions, EntityRelations.Transaction_LineItem, QueryStrategy.Normal);
        EntityList ticketSales =
          pm.GetChildren(lineItems, EntityRelations.LineItem_TicketSale, QueryStrategy.Normal);

        return ticketSales;
      }
    }

Greg Dunn

Relations with more than one entity in between? : Hi, I reviewed the video tutorial...

Fri, 19 Sep 2008 22:24:28 -700

Author: HFloyd
Subject: 943
Posted: 19-Sep-2008 at 10:24pm

Hi,

I reviewed the video tutorial on Many-to-Many relations, but can't figure out how to apply it to a relationship that has more than a single entity between the two entities.

Here is my case:

I have a Household Entity, which can have many Transactions (like Orders). Each Transaction has many LineItems (like Orderdetail), certain of those LineItems could be for tickets to an event, in which case, related records are added to EventTicketSales (generally including the names of the guests attending the event), so for a LineItem of "Event Tickets Qty = 4", four separate EventTicketSales would be created.

Here is a diagram of the relations:
Household --> Transaction --> LineItem --> EventTicketSale

I was able to follow the tutorial to create a relation property in Transaction for "EventTicketSales", but an unsure how to create a relation property in Household for "EventTicketSales" since "EntityRelations.Transaction_EventTicketSale" doesn't exist.

Is there some way to accomplish this?

Thank you!

Heather

DevForce Community Forum : Relations with more than one entity in between?

Relations with more than one entity in between? : I believe this should work (in...

Relations with more than one entity in between? : Hi, I reviewed the video tutorial...