Update collection in Entity Framework in disconnected state

Asked May 28 '20 at 14:51

Active May 29 '20 at 10:09

Viewed 141 times

class Parent
{
    public int id;
    public ICollection<Child> Children;
}

class Child
{
    public int id;
    public int childProperty1;
    public decimal? childProperty2;
    public string childProperty3;
    public Parent parent;
}

My code for attaching child entity to dbContext:

// Getting the DbContext
            DatabaseContext dbContext = dbContextScope.DbContexts.Get<DatabaseContext>();

            // Attaches the modified entity to context in disconnected architecture.
            dbContext.Parent.Attach(this.parent);
            dbContext.Entry(this.parent).State = EntityState.Modified;

            this.parent.children.Select(s => dbContext.Entry(s).State = EntityState.Modified);

            // SaveChanges
            await dbContextScope.SaveChangesAsync().AnyContext();

Update: Added this piece of code insted of the .Select():

foreach(var childEntity in this.parent.Children)
{
    dbContext.Child.Attach(childEntity);
    dbContext.Entry(childEntry).State = EntityState.Modified;
}

My dbContext is in disconnected state. I have to save the parent class and a collection of child class records say 5 child class records to the database. How can I achieve that? I have gone through these links:

update disconnected object in entity framework

Updating collection in EF

Storing a complex detached object graph in EF6

edited May 29 '20 at 10:09

asked May 28 '20 at 14:51

Shaswat Swarup

1

`Attach` from the first link does not work? – Guru Stron May 28 '20 at 15:27
It works but only for the parent and not for the child properties. – Shaswat Swarup May 28 '20 at 16:20
Have you tried to attach child properties? – Guru Stron May 28 '20 at 16:31
Yes. I tried that too. But it didn't work either. – Shaswat Swarup May 29 '20 at 04:52
Please add your attach/update code – Guru Stron May 29 '20 at 06:05
@GuruStron, mentioned in my question. Please have a look. – Shaswat Swarup May 29 '20 at 06:58
Try adding `foreach(var child in this.parentEntity.childrenEntity){ dbContext.Children.Attach(child ); }` before the select. – Guru Stron May 29 '20 at 07:27
Yes, when the select didn't work, I tried with foreach statement too. That did not work either. – Shaswat Swarup May 29 '20 at 09:49
Have you tried both? first attach then set state to modified? – Guru Stron May 29 '20 at 09:51
What version of EF? – Guru Stron May 29 '20 at 10:16
Entity Framework v.6.14 – Shaswat Swarup May 29 '20 at 10:26

Update collection in Entity Framework in disconnected state

0 Answers0