Gotcha: Entity Framework gets slow in long Iteration Loops

Thought I’d highlight a common problem I’ve run into a few times with a few of my customers using Entity Framework. I spent some time today with a customer debugging a very, very slowly process using Entity Framework operation. The customer was running a long order processing task involving an order with many thousands of order items plus a boat load of child items. This task is pretty massive, but it was taking 6+ hours to complete. Yikes. Lots of items for sure, but there’s no reason this should take hours or even more than a few minutes.