DevForce Community Forum : Custom Association with multiple criteria http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Custom Association with multiple criteria Wed, 13 May 2026 07:15:23 -700 Thu, 26 Apr 2012 14:50:20 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3396 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Custom Association with multiple criteria : Hi Von,You won't be able... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13436#13436 Author: sbelini
Subject: 3396
Posted: 26-Apr-2012 at 2:50pm

Hi 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.
]]> Thu, 26 Apr 2012 14:50:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13436#13436 Custom Association with multiple criteria : Hi Silvio,Would that be possible... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13411#13411 Author: Vonzkie
Subject: 3396
Posted: 25-Apr-2012 at 1:35am

Hi Silvio,

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

THanks,
Von
]]> Wed, 25 Apr 2012 01:35:30 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13411#13411 Custom Association with multiple criteria : Von, You might want to take... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13399#13399 Author: sbelini
Subject: 3396
Posted: 24-Apr-2012 at 11:50am

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/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/2010/12/06/ef-feature-ctp5-fluent-api-samples.aspx
http://social.msdn.microsoft.com/Forums/is/adodotnetentityframework/thread/2cb02baa-0b23-48b3-a529-92d56c6ff7dd
 
I hope this helps.
 
Regards,
   Silvio.
]]> Tue, 24 Apr 2012 11:50:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13399#13399 Custom Association with multiple criteria : Hi Silvio,Here's the original... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13382#13382 Author: Vonzkie
Subject: 3396
Posted: 23-Apr-2012 at 5:45pm

Hi Silvio,

Here's the original problem that we solved.

Customer
CustomerID
Name
LocationID

Invoice
InvoiceID
CustomerID
Description
InvoiceLocationID

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

Customer  Invoice
CustomerID =  CustomerID
LocationID   =  LocationID

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

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
]]> Mon, 23 Apr 2012 17:45:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13382#13382 Custom Association with multiple criteria : Von,Not sure I understand... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13373#13373 Author: sbelini
Subject: 3396
Posted: 23-Apr-2012 at 10:09am

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.
]]> Mon, 23 Apr 2012 10:09:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13373#13373 Custom Association with multiple criteria : Hi Silvio,That works for us.However,... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13372#13372 Author: Vonzkie
Subject: 3396
Posted: 22-Apr-2012 at 11:31pm

Hi 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
]]> Sun, 22 Apr 2012 23:31:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13372#13372 Custom Association with multiple criteria : In model first you mark the... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13363#13363 Author: sbelini
Subject: 3396
Posted: 19-Apr-2012 at 4:27pm

 
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
 
Silvio.
]]> Thu, 19 Apr 2012 16:27:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13363#13363 Custom Association with multiple criteria : Hi,I'll try to look at it.... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13362#13362 Author: Vonzkie
Subject: 3396
Posted: 19-Apr-2012 at 4:14pm

Hi,

I'll try to look at it. :)
How about not Code First?

Thanks,
VOn
]]> Thu, 19 Apr 2012 16:14:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13362#13362 Custom Association with multiple criteria : Hi Vonzkie,Are you talking about... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13356#13356 Author: sbelini
Subject: 3396
Posted: 19-Apr-2012 at 12:22pm

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:
 
Column("CustomerID", Order=0)]
 
You can check our Code First samples in the DevForce Resource Center for more details in creating CodeFirst Entities/Navigation Properties.
 
Regards,
   Silvio.
]]> Thu, 19 Apr 2012 12:22:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13356#13356 Custom Association with multiple criteria : Correction:Customer InvoiceCustomerID... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13347#13347 Author: Vonzkie
Subject: 3396
Posted: 19-Apr-2012 at 2:45am

Correction:

Customer  Invoice
CustomerID =  CustomerID
LocationID   =  InvoiceLocationID 
]]> Thu, 19 Apr 2012 02:45:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13347#13347 Custom Association with multiple criteria : Hi,How can I create a custom association... http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13346#13346 Author: Vonzkie
Subject: 3396
Posted: 19-Apr-2012 at 2:44am

Hi,

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

E.g: 

Customer
CustomerID
Name
LocationID

Invoice
InvoiceID
CustomerID
Description
InvoiceLocationID

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

Customer  Invoice
CustomerID =  CustomerID
LocationID   =  LocationID

How can I do that?

Thanks,
Von



]]> Thu, 19 Apr 2012 02:44:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3396&PID=13346#13346