Although I dislike answering my own questions, here is what I did to get the solution:...Following my discovery of this ...Advanced Types... link I tried a few different implementations, and in the end I came up with this....It is not necessary to do several joins in order to get the list items since the List values are directly stored on the datab...
Instead of navigation properties, you should designate with the needed attribute simple properties:...[Table("PbnJobs")]
public abstract class PbnJob : Job
{
public virtual PbnSite Site{ get; set; }
[ForeignKey("Site")]
[Required]
public int SiteId { get; set; }
}
...Given that your foreign key property cannot be null, Required is ...
Since I can't tell from the sample code, even if this is probably not the case, do you have the...Html.BeginForm(){}...
block surrounding the model you're attempting to post? could try altering the...<button>...
tag to...<input type='submit' value='save status'/>...
instead
I can infer from what I see that those rows are for the implementation of units of work (UOW)....In essence, RowNumberValue, IsNew, and IsModified are used for Paging. IsNew is used to denote an entity that was added, while IsModified is for an entity that is pending an update....If the answer is still accurate, then ODP ...https://stackoverflow.co...
When entity framework creates the underlying sql statements, it uses the table alias Extent1. The problem indicates that EF is either improperly configured or incorrectly interprets the structure of your database....You must examine the query that underlies it and figure out why EF uses a field that it is not supposed to. Most likely, a relationshi...
