Entity Framework gets slow in long Iteration Loops about cleanarchitecture

[ardalis]

The default EF Core lifetime is Scoped, which has nothing to do with StructureMap (but StructureMap will use this if it's used as the container as in this case). If you want to create separately-scoped instances of DbContext, you can create child scopes as described here:

https://stackoverflow.com/questions/43722463/how-to-create-a-child-scope-from-the-parent-with-default-dependency-injection-in

You might at that point need to pass the dbContext into a new instance of a repo you create yourself, rather than requesting one from the container. Let me know if that helps/makes sense.

[hugodamiaodias]

Sorry it took me so long to get back to this.

I did not manage to solve the issue using your suggestion, but I'll leave here my workaround, in case it can be useful to someone else.

Basically I had a set of events that lead to a loop on 1000+ insertions, and as the dbContextkept everything in memory, it started to get slower and slower...

My solution was to detach all entities from the dbContext after each insertion, as they were not needed anymore.

...
// The event handler that dealt with the 1000+ similar events and thus generated 1000+ inserts
public void HandlePost(MyEntityCreatedEventPost domainEvent)
{
    ...
    _aggregate.Insert(entity);  // note: does a dbContext.SaveChanges()
    _aggregate.DetachAll();
    ...
}

// And the cleanup method to keep the dbContext nimble
public void DetachAll()
{
    foreach (EntityEntry dbEntityEntry in _dbContext.ChangeTracker.Entries().Where(e => e.Entity != null).ToList())
    {
        dbEntityEntry.State = EntityState.Detached;
    }
}