At what point should I use the SaveChanges() method while generating numerous Entity Framework entities (such as during an import)?

asked 2023-05-12 19:59:45 +0000

bukephalos
21 ●4 ●3

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2023-05-12 20:27:02 +0000

huitzilopochtli
41 ●4 ●3

It is recommended to use the SaveChanges() method after generating a batch of entities, such as after importing a certain number of records or after processing a certain number of entities. This helps to improve performance and reduces the risk of data loss in case of a failure. You can experiment with different batch sizes to find the optimal batch size for your particular scenario.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools

Stats

Asked: 2023-05-12 19:59:45 +0000

Seen: 10 times

Last updated: May 12 '23

At what point should I use the SaveChanges() method while generating numerous Entity Framework entities (such as during an import)? edit

1 Answer