http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/ADO.Net Entities / Associationshttp://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/en-usThu, 09 Jul 2009 14:55:15 GMTThu, 09 Jul 2009 14:55:15 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)<p>I have the exact same problem.&nbsp; it doesn't appear entity framework likes composite keys.&nbsp; very frustrating.</p>http://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/?CommentID=477661Thu, 09 Jul 2009 14:55:15 GMThttp://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/?CommentID=4776610http://channel9.msdn.com/477661/WebViewBug.aspx?EVT=0I have the exact same problem.&nbsp; it doesn't appear entity framework likes composite keys.&nbsp; very frustrating.bap0http://channel9.msdn.com/477661/Trackback.aspx<p>Any progress on this? I'm having the same problem now.</p> <p>I have a couple of tables, Employees and&nbsp;SecurityClearance. There are no relationships defined in the SQL Server database. They both have composite keys and I get this error when creating an association between the two.</p> <p>&nbsp;</p> <div>Error 1 Error 111: Properties referred by the Principal Role DLPSSECL must be exactly identical to the key of the EntityType Model.DLPSSECL referred to by the Principal Role in the relationship constraint for Relationship Model.DLPSSECLDLEPEM. Make sure all the key properties are specified in the Principal Role. C:\Documents and Settings\simonb\My Documents\Visual Studio 10\Projects\WpfApplication1\WpfApplication1\Model1.edmx 1 1 WpfApplication1</div> <p>&nbsp;</p> <p>Properties referred by the Principal Role SecurityClearance must be exactly identical to the key of the EntityType Model.&nbsp;SecurityClearance&nbsp;referred to by the Principal Role in the relationship constraint for Relationship Model.&nbsp;SecurityClearanceEmployee. Make sure all the key properties are specified in the Principal Role.</p> <p>&nbsp;</p> <pre><strong>Employee</strong></pre> <pre>CompanyID (Int16) PK</pre> <pre>EmployeeID (Int32) PK</pre> <pre>SecurityClearance (string)</pre> <pre>Other data fields...</pre> <pre><br /></pre> <pre>SecurityClearance</pre> <pre>CompanyID (Int16) PK</pre> <pre>SecurityClearance (string) PK</pre> <pre>Other data fields...</pre> <p>&nbsp;</p> <p>Association is between SecurityClearance and Employee (1 to Many).</p> <p>Mappings:</p> <pre>Maps to Employee</pre> <pre>&nbsp;&nbsp;SecurityClearance:</pre> <pre>&nbsp;&nbsp; &nbsp; &nbsp;CompanyID : Int16 &nbsp;&lt;-&gt; CopmanyID : smallint (key field on Employee table)</pre> <pre>&nbsp;&nbsp; &nbsp; &nbsp;SecurityClearance : String &lt;-&gt;SecurityClearance : char (data field on Employee table)</pre> <pre>&nbsp;&nbsp;Employee</pre> <pre>&nbsp;&nbsp; &nbsp; &nbsp;CompanyID : Int16 &nbsp;&lt;-&gt; CopmanyID : smallint (key field on Emlpoyee table)</pre> <pre>&nbsp;&nbsp; &nbsp; &nbsp;EmployeeID : Int32 &nbsp;&lt;-&gt; &nbsp;EmployeeID : int (key field on Employee table)</pre> <p>&nbsp;</p> <p>Is creating an association in the EDMX on composite keyed tables like this supported? I've tried it in both EF v3.5 and EF v4.0 in the VS2010 beta and get the same error message when running model validation.</p> <p>Cheers,</p> <p>Simon</p>http://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/?CommentID=476732Thu, 02 Jul 2009 23:05:52 GMThttp://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/?CommentID=4767320http://channel9.msdn.com/476732/WebViewBug.aspx?EVT=0Any progress on this? I'm having the same problem now. I have a couple of tables, Employees and&nbsp;SecurityClearance. There are no relationships defined in the SQL Server database. They both have composite keys and I get this error when creating an association between the two. &nbsp; Error 1 Error&#8230;Simon Brangwin0http://channel9.msdn.com/476732/Trackback.aspx<a href="http://www.filefactory.com/file/a021673/n/EfExample2_zip"></a><a href="http://www.mediafire.com/?sharekey=70e2aa9ef2d123feed24a2875c7fa58ee04e75f6e8ebb871" target="_blank">Example Project</a><br />http://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/?CommentID=453608Fri, 16 Jan 2009 09:41:10 GMThttp://channel9.msdn.com/forums/TechOff/453607-ADONet-Entities--Associations/?CommentID=4536080http://channel9.msdn.com/453608/WebViewBug.aspx?EVT=0Example ProjectJohn0http://channel9.msdn.com/453608/Trackback.aspx