How can I create a custom association in Devforce that have multiple criteria?

E.g: 

CustomerID

Name

LocationID

InvoiceID

CustomerID

Description

InvoiceLocationID

I want to have a one to many relationship with Customer and Invoice but the criteria would be:

CustomerID =  CustomerID

LocationID   =  LocationID

How can I do that?

Thanks,

Von

CustomerID =  CustomerID

LocationID   =  InvoiceLocationID 

Hi Vonzkie,

 

Are you talking about Code First?

 

If that's the case you must set the order of the PK when working with composite keys:

 

 

You can check our Code First samples in the http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-code-first-tour - DevForce Resource Center for more details in creating CodeFirst Entities/Navigation Properties.

 

Regards,

   Silvio.

I'll try to look at it. :)

How about not Code First?

Thanks,

VOn

 

In model first you mark the properties as Entity Keys and set the Referential Constraint accordingly.

In database first, you will find a solution at http://stackoverflow.com/questions/1545571/how-do-i-make-a-composite-key-with-sql-server-management-studio - http://stackoverflow.com/questions/1545571/how-do-i-make-a-composite-key-with-sql-server-management-studio

 

Silvio.

That works for us.

However, since let's say for example I have my table marked 2 of its column as Entity Key and tried to associate it again with another table but I don't need the criteria being map to the other column. How would I do it?

Thanks,

Von

 

Not sure I understand the question.

You are trying to associate 2 tables, but don't want to use the PK_FK association?

 

Please clarify.

 

Silvio.

Hi Silvio,

Here's the original problem that we solved.

CustomerID

Name

LocationID

InvoiceID

CustomerID

Description

InvoiceLocationID

I want to have a one to many relationship with Customer and Invoice but the criteria would be:

CustomerID =  CustomerID

LocationID   =  LocationID

Now, what about adding another table and link it with Customer such as CustomerDetails

DetailID

Description

CustomerID

How do I associate this to Customer by bypassing the LocationID because I don't need it in this association.

Thanks,

Von

You might want to take a look at the Code First documentation on details on how to accomplish your objective (if possible):

 

http://msdn.microsoft.com/en-us/data/aa937723 - http://msdn.microsoft.com/en-us/data/aa937723

http://msdn.microsoft.com/en-us/data/hh134698 - http://msdn.microsoft.com/en-us/data/hh134698

http://blogs.msdn.com/b/adonet/archive/2011/03/15/ef-4-1-code-first-walkthrough.aspx - http://blogs.msdn.com/b/adonet/archive/2011/03/15/ef-4-1-code-first-walkthrough.aspx

http://blogs.msdn.com/b/adonet/archive/2010/12/06/ef-feature-ctp5-fluent-api-samples.aspx - http://blogs.msdn.com/b/adonet/archive/2010/12/06/ef-feature-ctp5-fluent-api-samples.aspx

http://social.msdn.microsoft.com/Forums/is/adodotnetentityframework/thread/2cb02baa-0b23-48b3-a529-92d56c6ff7dd - http://social.msdn.microsoft.com/Forums/is/adodotnetentityframework/thread/2cb02baa-0b23-48b3-a529-92d56c6ff7dd

 

I hope this helps.

 

Regards,

   Silvio.

Would that be possible with Database First Design? Are there some workarounds?

THanks,

Von

 

You won't be able to create an association where the FK is part of a composite key. Since it's just a FK you better off simply adding it to your CustomerDetails entity.

 

Since this is more of a design question I think you'd benefit more from our Professional Services Team assistance.

Let me know if this interests you, so I can have someone get in touch with you in this regard.

 

Silvio.