如何在LINQ to SQL中一次插入多个记录，同时在每个插入上调用序列检索功能

var db = new StoreDataContext();
using(var scope = new TransactionScope()){        
    foreach(var p in payments){
        db.payments.Insert(new payment 
                          {    order_fk = p.order_fk, 
                               line_no = DbMethods.GetNextLine(p.order_fk),     
                                amount = p.amount
                          });
        db.SubmitChanges(ConflictMode.FailOnFirstConflict);
    }
    scope.Complete();
}

var db = new StoreDataContext();
Int32 lineNo = DbMethods.GetNextLine(p.order_fk);
var inserts = payments.Select(p => new payment 
{
  order_fk = p.order_fk,
  amount = p.amount
});
foreach(var item on inserts)
{
  item.line_no = LineNo;
  LineNo++;
}
db.payments.InsertAllOnSubmit(inserts);
db.SubmitChanges(ConflictMode.FailOnFirstConflict);