Htykuut

I seem to have the a similar issue as is cited here, but there are no satisfactory answers on that post - This SqlTransaction has completed; it is no longer usable.

Specifically, I use InsertOnSubmit to insert 100 objects into one of the tables in my data context, and then I call SubmitChanges on the data context. Every once in a while, when I call SubmitChanges, I get the error in the title of this question.

I create a new data context just after the SubmitChanges every 500 records. So my code looks like this:

        DataContext writeDataContext = new DataContext(myConnectionString);

        List<MyCalculation> calculationsToAdd = new List<MyCalculation>();



        foreach (var transaction in transactions)

        {                    

           var myCalculation = new MyCalculation { MyTransactionID = transaction.TransactionID, MyValue = transaction.Amount * 2 };

           writeDataContext.GetTable<MyCalculation>().InsertOnSubmit(myCalculation);



           calculationsToAdd.Add(myCalculation);



           contextCounter++;



           if (calculationsToAdd.Count == 100)

            {

                writeDataContext.SubmitChanges();

                calculationsToAdd.Clear();



                if (contextCounter >= 500)

                {

                    writeDataContext = new DataContext(myConnectionString);

                    contextCounter = 0;

                }

            }

         }

In another spot I also have seen this error, and what I'm doing there is even simpler - refreshing the data context just after the SubmitChanges every time that I submit changes.

I've looked on the internet, and am not finding anything to help. Any suggestions will be very welcome! Thanks in advance!