User-1637592233 posted
During the Edit I have to update some of the tables with the value from the form, and also have to add some new records on the table.
I am always getting the same error:
The operation failed: The relationship could not be changed because one or more of the foreign-key properties is non-nullable. When a change is made to a relationship, the related foreign-key property is set to a null
value. If the foreign-key does not support null values, a new relationship must be defined, the foreign-key property must be assigned another non-null value, or the unrelated object must be deleted.
My view model is as below:
public class CorporateCustomerUpdateViewModel
{
public Guid Id { get; set; }
public string FullName { get; set; }
public CorporateCustomerViewModel CorporateCustomer { get; set; }
}
public class CorporateCustomerViewModel
{
public int BusinessTypeId { get; set; }
public List<CorporateMemberViewModel> CorporateMembers { get; set; }
}
public class CorporateMemberViewModel
{
public string IdNumber { get; set; }
public string Name { get; set; }
public string Document { get; set; }
}
Entities::
public class User
{
public Guid Id { get; set; }
public string FullName { get; set; }
public virtual CorporateCustomer CorporateCustomer { get; set; }
}
public class CorporateCustomer
{
public int BusinessTypeId { get; set; }
public virtual ICollection<CorporateMember> CorporateMembers { get; set;}
}
public class CorporateMember
{
public string IdNumber { get; set; }
public string Name { get; set; }
public string Document { get; set; }
}
I am using AutoMapper to map the fields from view models to entities.
Configuration looks like:
public class CorporateCustomerMapper : Profile
{
CreateMap<CorporateCustomerUpdateViewModel, User>();
}
I am trying to Update the User table as below:
public void UpdateCorporateCustomerDetail(CorporateCustomerUpdateViewModel model)
{
var userRepo = _genericUnitOfWork.GetRepository<User, Guid>();
var user = userRepo.GetById(model.Id);
var entity = _mapper.Map(model, user);
//mapping CorporateCustomerUpdateViewModel to User
userRepo.Update(entity);
_genericUnitOfWork.SaveChanges();
}
GetById
public TEntity GetById(TKey id)
{
return _dbSet.Find(id);
}
After the MAP the user.CorporateCustomer.CorporateMembers is getting null because there is no value on model.CorporateCustomer.CorporateMembers.
But that should not be getting null because there are already some CorporateMembers in the database which I get during GetById.
I think here is the problem because EF is going to update the null entry.
Here in the link provided is the discussion about the same scenarios.
https://stackoverflow.com/questions/5538974/the-relationship-could-not-be-changed-because-one-or-more-of-the-foreign-key-pro
https://stackoverflow.com/questions/5538974/the-relationship-could-not-be-changed-because-one-or-more-of-the-foreign-key-pro
I have gone through both the links. But there are the discussion with one ChildObjects and no AutoMapper. I cannot figure out where did I actually did something wrong, and where I should change my code.
Please can you suggest some code changes, or some hints?
Entity Framework update the parents and add the child objects. Getting error
