I worked on this topic for a day before realizing that the model.edmx file was the source of the problem....Each EntitySet has a line in this file.
A schema property exists on each EntitySet element. This property is assigned to the corresponding table structure in the case of SQL Server:...EntitySet Name="annee_civile"
EntityType="openemisModel....
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...
You're using the incorrect generator. Only those techniques are produced by...EntityObject...
built-in generator (the one which is deprecated). These partial methods are not generated by the default generator since it uses POCO classes; however, you can change the generator to include them (it is a T4 template)....To use...EntityObject...
generato...
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
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...
