DevForce Community Forum : relationship mapping on foreign keys http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : relationship mapping on foreign keys Thu, 16 Apr 2026 15:58:08 -700 Tue, 10 Feb 2009 12:01:37 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1087 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ relationship mapping on foreign keys : First I should say that because... http://www.ideablade.com/forum/forum_posts.asp?TID=1087&PID=3907#3907 Author: kimj
Subject: 1087
Posted: 10-Feb-2009 at 12:01pm

First I should say that because DevForce EF uses the ADO.NET Entity Framework for the underlying entity model that we're dependent on the rules enforced by EF, which are in general somewhat strict.  What you're seeing here is a message from EF as you build your model via the Entity Data Model designer, so the error itself is not raised by DevForce. 

Apparently this error is a known limitation in EF - here's what a Microsoft engineer said on the ADO.NET EF forum:
Yes, this is a restriction of the current version of the EF: It does not allow foreign keys which are only partly inside of the primary key. It is not a limitation of the tools, but of the framework itself."
 
In your situation I don't know if it would make sense to a) not mark the Employee.OrganizationId as part of the primary key, or b) add OrganizationId to the Person table, or c) add surrogate keys to these tables, or d) leave the association unmapped. 
 
]]> Tue, 10 Feb 2009 12:01:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1087&PID=3907#3907 relationship mapping on foreign keys : Hi, We are having a problem... http://www.ideablade.com/forum/forum_posts.asp?TID=1087&PID=3895#3895 Author: egoren
Subject: 1087
Posted: 09-Feb-2009 at 2:37pm

Hi,
 
We are having a problem with DevForce EF.
We have the following database schema:
Person { *PersonId }
Employee { *PersonId, *OrganizationId, PositionId }
Position { *PositionId, *OrganizationId }
[The * represents the primary key(s)]
When adding the table in the ebmx diagram, the relation between Employee and Position is not created and we receive this error :
warning 6030: The relationship 'FK_Employee_Position' uses the set of foreign keys '{OrganizationId, PositionId}' that are partially contained in the set of primary keys '{OrganizationId, PersonId}' of the table 'Employee'. The set of foreign keys must be fully contained in the set of primary keys, or fully not contained in the set of primary keys to be mapped to a model.
Is there a way to create this relation in DevForce EF like we could (and do) in DevForce Classic?
]]> Mon, 09 Feb 2009 14:37:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1087&PID=3895#3895