Inserting 100 Records per Transaction

Question

Is it possible to insert only 100 records at a time per transactionScope? I would like to do things that way to avoid timeouts on my application.

using(var scope = new TransactionScope())
{

foreach ( object x in list)

        {
          // doing insertOnSubmit here
        }

context.SubmitChanges();
scope.Complete();

}

So I would like to insert only 100 or even 50 rows inside that transaction just to avoid timeouts.

Answer 1

Sure. Just start a new transaction every 50-100 records. What is your exact problem?

Answer 2

Something like this?

TransactionScope scope;
bool committed = false;
int i = 0;
const int batchSize = 100; // or even 50

try
{
    foreach ( object x in list)
    {
        if (i % batchSize == 0)
        {
            if (scope != null)
            {
                scope.Commit();
                scope.Dispose();
                context.SubmitChanges();
            }
            scope = new TransactionScope();
        }

        // doing insertOnSubmit here
        ++i;
    }

    if (scope != null)
    {
        scope.Commit();
        context.SubmitChanges();
    }
}
finally
{
   if (scope != null) 
   {
       scope.Dispose();
   }
}