invalid association mapping http://forums.asp.net/t/1297516.aspx/1?invalid+association+mapping+Mon, 06 Jul 2009 14:07:48 -040012975162522950http://forums.asp.net/p/1297516/2522950.aspx/1?invalid+association+mapping+invalid association mapping <span id="_ctl0_MainContent_PostFlatView"><span><font size="2"><span style="font-family:Arial">Hi , wondering if anyone has any ideas to this within my class mapping. I think the answer maybe in my db structure. <br> Anyway, all thoughts very much appreciated. <br> </span></font><span></span> <h2><i><i>Invalid association mapping for member 'Asset.DesignImages'. &nbsp;'DesignImage' is not an entity</i></i></h2> I've notice VS studio is giving me warnings:<br> <br> <span style="color:rgb(255,0,0)">Warning&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; Value for property &quot;Discriminator Property&quot; cannot be empty.&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; </span><br style="color:rgb(255,0,0)"> <span style="color:rgb(255,0,0)">Warning&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; Value for property &quot;Inheritance Default&quot; cannot be empty.&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;</span>&nbsp;&nbsp; <br> <br> My DataBase<br> Asset<br> DesignText (foreignkey to asset.id )<br> DesignImage (foreignkey to asset.id )<br> <br> Maybe i'm gettng nulls???<br> <br> &nbsp;var query =<br> <br> &nbsp; from d in db.Designs<br> <br> &nbsp; from a in db.Assets<br> <br> &nbsp; select new ProductViewHelper()<br> <br> &nbsp; {<br> <br> &nbsp;&nbsp;&nbsp; theDesign = new Design(){DesignId = d.Id, Title = d.Title, DateField = DateTime.Now, PreviewImage = d.PreviewImage},<br> <br> &nbsp;&nbsp;&nbsp; theAsset = new Asset(){AssetId = a.Id, DesignId = a.DesignId, Date = a.Date},<br> <br> &nbsp;&nbsp;&nbsp; DesignTexts = (from x in a.DesignTexts select new DesignText()<br> <br> &nbsp;&nbsp;&nbsp; { DesignTextId = x.Id, Text = x.Text}).ToList(),<br> <br> &nbsp;&nbsp;&nbsp; DesignImages = (from y in a.DesignImages select new DesignImage()<br> &nbsp;&nbsp;&nbsp; <br> &nbsp;&nbsp;&nbsp; {Id = y.Id}).ToList()<br> <br> &nbsp; };<br> <br> <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; foreach (var p in query)<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br> &nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Response.Write(p.theAsset.id);<br> <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</span></span> 2008-07-29T18:58:38-04:003276929http://forums.asp.net/p/1297516/3276929.aspx/1?Re+invalid+association+mappingRe: invalid association mapping This is because the DesignImage table does not have a primary key. Entities are unique objects that need a descriminating key. So, either remove the relationship or add a primary key to the table. 2009-07-06T14:07:48-04:00