Entity Framework Insert stored procedure in a loop

Question

Trying to execute an insert stored procedure in a loop using Entity Framework, something like this:

var context = new Entities()
var items = context.GetAllItems().ToList();

foreach(var item in items) 
{
    // Other select and update procedures
    context.InsertProcedure(item.Prop1);
}

context.SaveChanges();

but I am getting an exception.

New transaction is not allowed because there are other threads running in the session

Anybody had this before?

This may happen if you have a select statement within your store procedure... do you have something like that?... if this is not the case there are 2 other options: Why do you need an 'Insert' sp if you are already using EF to map entities? Option 2. Have you considered the use of a TransactionScope ? — David Espino
– David Espino, Commented Dec 5, 2016 at 22:39
@DavidEspino There is a SELECT @@identity statement, I have to use the SP, its a reusable part used elsewhere, what is the transaction scope ? — Yaman
– Yaman, Commented Dec 5, 2016 at 22:55

Yaman · Accepted Answer · 2016-12-05 23:03:12Z

1

It turned out there is another exception, but looks like this exception is always thrown when there is a problem within the loop.

What I did is that I changed the return type of the stored procedure to None in Model Browser

answered Dec 5, 2016 at 23:03

Yaman

1,06117 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Insert stored procedure in a loop

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related