Revisions to Fastest Way of Inserting in Entity Framework

Post Reopened by dbc, Christophe, Christian Gollhardt

occurred May 30 at 10:36

Add information from comments

Source Link

edited May 29 at 17:58

119.7k
27
272
403

I'm looking for the fastest way of inserting in Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

Currently I am doing it as follows. Is there a more efficient way?

Creating the TransactionScope

instantiating the DBContext

Opening the connection

In a for-each statement doing the insertions and SavingChanges (for each record).

NOTE: TransactionScope and DBContext are in using statements, and I'm closing the connection in a finally block.

I'm looking for the fastest way of inserting in Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

I'm looking for the fastest way of inserting in Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

Currently I am doing it as follows. Is there a more efficient way?

Creating the TransactionScope

instantiating the DBContext

Opening the connection

In a for-each statement doing the insertions and SavingChanges (for each record).

NOTE: TransactionScope and DBContext are in using statements, and I'm closing the connection in a finally block.

Post Closed as "Opinion-based" by Gert Arnold, TylerH, Chris

occurred May 13 at 12:35

deleted 2 characters in body

Source Link

edited Jul 7, 2023 at 21:25

John Smith

7.4k
7
52
63

I'm looking for the fastest way of inserting intoin Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

I'm looking for the fastest way of inserting into Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

I'm looking for the fastest way of inserting in Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

added 2 characters in body

Source Link

edited Jul 3, 2020 at 13:36

Selim Yildiz

5.4k
6
22
34

I'm looking for the fastest way of inserting into Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScopeTransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

I'm looking for the fastest way of inserting into Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.

I'm looking for the fastest way of inserting into Entity Framework.

I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), and this will lead to an incomplete transaction.