http://forums.asp.net/1147.aspxSetup issues and general questions regarding this release. For specific topics use <a href="http://forums.asp.net/1146.aspx">ASP.NET MVC</a>, <a href="http://forums.asp.net/1154.aspx">ASP.NET Controls for Silverlight</a>, <a href="http://forums.asp.net/1145.aspx">ASP.NET Dynamic Data</a>, <a href="http://go.microsoft.com/fwlink/?linkid=96773">ADO.NET Entity Framework</a>, <a href="http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1430&SiteID=1">ADO.NET Data Services</a> or the <a href="http://forums.asp.net/1008.aspx">ASP.NET AJAX UI</a> forum.enCommunityServer 2007 SP1 (Build: 20510.895)http://forums.asp.net/thread/3175725.aspxWed, 20 May 2009 13:53:35 GMT4c671506-2930-414c-a40b-8bf57ded5924:3175725cgeers0http://forums.asp.net/thread/3175725.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=1147&PostID=3175725<p>Jumpingmattflash,</p> <p>Setup your database structure as follows:</p> <p><strong>Table [Person]</strong></p> <ul> <li> <div>PersonId (Primary key)</div></li> <li> <div>Name</div></li> <li> <div>PersonTypeId</div></li></ul> <p><strong>Table [PersonType]</strong></p> <ul> <li> <div>PersonTypeId (Primary key)</div></li> <li> <div>Name</div></li></ul> <p>Put a foreign key on the [Person] table pointing to the [PersonType] table (Person.PersonTypeId -&gt; PersonType.PersonTypeId). You should link a person to a type using the primary key value of the PersonType table, not the value of the name of the type.</p> <p>Next add a new Entity Data Model to your solution and have it generate a model from this database. Just select those two tables to include in the model.</p> <p>If you are having trouble with this, please send me a private message and I&#39;ll whip up an example.</p> <p>Regards,</p> <p>Christophe</p> <p>&nbsp;</p>http://forums.asp.net/thread/3115637.aspxFri, 24 Apr 2009 09:14:48 GMT4c671506-2930-414c-a40b-8bf57ded5924:3115637jumpingmattflash0http://forums.asp.net/thread/3115637.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=1147&PostID=3115637Hi guys, I think i&#39;m missing the point somewhere along the line when it comes to entity framework but i&#39;m convinced I should be able to to do this. I&#39;ve got two related tables, for the sake of argument lets call them person(personid, surname) and persontype(persontypeid, name). Person must have a persontype and a persontype can be assigned to zero or more person records. So I create the data model from my database and it sows up the correct linkage. I copy the persontype.name property into person and setup the mapping details so that person maps to persontype and the name property originates from persontype.name. Seems simple enough.. It won&#39;t compile now though, even if I remove the persontype entity from my page. The error I get is &quot;Error 3024: Problem in mapping fragment.. Must specify mapping for all key properties (Person.PersonID, Person.PersonTypeID) of the EntitySet Person I&#39;m at a loss as to where to go now, if I cant solve this issue i&#39;m struggling to see the benefit in using Entity Framework over LINQ to SQL. Thanks, Matt