Entity Framework the order sql generated by Savechanges()

Question

I am looking at the sql executed when I call SaveChanges on context, it does update , delete and insert sql stament in that order.. is there a way to change it to delete , update , insert ?

score 2 · Answer 1 · edited May 23 '17 at 12:17

2

The only way that I can think of is to call your Delete() first then SaveChanges() then do the rest Insert() and Update(). Not saying that is the only way...

Looks like there is no way to change the order... - DbContext SaveChanges Order of Statement Execution

edited May 23 '17 at 12:17

Community

1
1

answered Mar 02 '12 at 17:32

bytebender

7,371
2
31
54

This answer is correct. To add a little, SaveChanges generates an order based on constraints between different tables/rows such that the save would succeed. Often using a different order will fail with constraint violations, at least on SQL Server and many other databases. – Arthur Vickers Mar 03 '12 at 00:47

score -4 · Answer 2 · answered Nov 13 '12 at 13:08

-4

SaveChanges execute your changes in the same order that you added them to the datacontex. Make sure that you add them in the right order or at least an order that allows them to be executed.

answered Nov 13 '12 at 13:08

Keren

81
2
10

It's not guaranteed that changes will be done in the order you added – syned Jul 10 '14 at 11:06
Definitely not true. Just tested that myself. – Crono Jul 21 '15 at 00:51

Entity Framework the order sql generated by Savechanges()

2 Answers2

Linked