Updating Parent Child entities with EF

1 posts, 0 answers
  1. Vandana
    Vandana avatar
    3 posts
    Member since:
    Jul 2010

    Posted 16 Jul 2010 Link to this post

    I have the following parent child relationship Employee > Employee Address with the relationship being 1 : n. I want to update the employee information as well as employee address at the same time. I am presently able to achieve this using the following code

    System.Data.Objects.DataClasses.

     

    EntityCollection<EmployeeAddress> address = new System.Data.Objects.DataClasses.EntityCollection<EmployeeAddress>();

     

    address.Add(

     

     

    new EmployeeAddress { Id = 10, EmployeeId = 33, Line1 = "Modified Line 1" });

     

    emp =

     

     

    new Employee() { Id = 33, Name = "ABC", Age = 50};

     

    testDBContext.Employees.Attach(

     

     

    new Employee { Id = emp.Id });

     

    testDBContext.EmployeeAddresses.Attach(

     

     

    new EmployeeAddress { Id = address.First().Id });

    testDBContext.Employees.ApplyCurrentValues(emp);

    testDBContext.EmployeeAddresses.ApplyCurrentValues(emp.EmployeeAddresses.First());

    testDBContext.SaveChanges();

    I have to perform two different operations to save the parent and child record. Is there any other efficient / better way to do this? I am presently in the EF learning phase. Any help on this will be highly appreciated. 

    Thanks,

    Vandana

Back to Top