Hi
I went the model first route, created my classes and generated the database.
Amongst that, 3 tables have been created (Club, League & Manager - where a club belongs to a league, and each club has a manager), with their foregin key references, all looks correct on the database side.
In my MVC web application, when inserting a new record, no matter how I assign the Manager and league, it seems that the sql insert statements written by entity framework do not include the ID's for the league and manager columns. I am constantly running into:
Cannot insert the value NULL into column 'Manager_Id', table 'KZNIHA.dbo.Clubs'; column does not allow nulls. INSERT fails. The statement has been terminated.
I've tried this:
using (var model = ModelProvider.GetModelContainer())
{
newClub.League = model.Leagues.Where(l => l.Id == leagueID).First();
newClub.Manager = model.Contacts.Where(c => c.Id == mgrId).First();
model.AddToClubs(newClub);
model.SaveChanges();
}
}
And this:
using (var model = ModelProvider.GetModelContainer())
{
newClub.League = (from l in model.Leagues where l.Id == leagueID select l).First();
newClub.Manager = (from c in model.Contacts where c.Id == mgrId select c).First();
model.AddToClubs(newClub);
model.SaveChanges();
}
And even this:
using (var model = ModelProvider.GetModelContainer())
{
newClub.LeagueReference.EntityKey = new System.Data.EntityKey("ModelContainer.Leagues", "Id", leagueID);
newClub.ManagerReference.EntityKey = new System.Data.EntityKey("ModelContainer.Contacts", "Id", mgrId);
model.AddToClubs(newClub);
model.SaveChanges();
}
Nothing works. No matter how i assign the sub class properties, the id's do not seem to make it into the sql insert statement.
Can anyone point me towards the light here? What am I doing wrong?
