So, I have a DBContext, and I am doing the following operations:
dbContext.SomeTables1.Add(object1) dbContext.SomeTables2.AddRange(objectArray2) dbContext.SomeTables3.AddRange(objectArray3) dbContext.SaveChanges();
The EF doesn't insert the db records in this order, it inserts them in a random order. To insert them in the same order, I have to do a
dbContext.SaveChanges() after each addition. This is not an efficient solution and in my case, it is taking 10 seconds to do all my inserts, while the random order with one save takes around 3 seconds.
N.B. I need the right order to solve a deadlock issue.
My questions are:
- Is this issue resolved in EF7?
- I can profile EF and determine the random order, however, is there a guarantee that it will be consistently with the same random order or does it change between requests? (I can adopt my other code if the answer to this question is positive).
- Is there a better way of maintaining the order than
dbContext.SaveChanges()on every addition?
When you call SaveChanges, all entities are ordered from an internal order in the method â€œProduceDynamicCommandsâ€ then sorted again by the method â€œTryTopologicalSortâ€ which loops to add command with no predecessor left (if you add A and B and A depend on B, then B will be inserted before A)
You are left to insert by batch addition.
Since it takes you 3 seconds to perform your insert, I will assume you have thousands of entities and performing bulk insert may improve your performance to reduce the 10 seconds to less, and then maybe the initial 3 seconds!
Here are 2 libraries I can recommend:
Disclaimer: I'm the owner of the Entity Framework Extensions project.
You could order it before using the Add function and then use the save? Would it help/have your tried this?