问在submitChanges之前检测LINQ插入并使用BulkInsert代替

EN

SchedDB.Data.SchedulerDBDataContext db = new SchedDB.Data.SchedulerDBDataContext();
//Do a bunch of stuff to populate "db"
db.SubmitChanges()

SchedDB.Data.SchedulerDBDataContext db = new SchedDB.Data.SchedulerDBDataContext();
//Do a bunch of stuff to populate "db"
//NEW: Detect all of the inserts in the "db" object.  Remove those inserts and generate code to insert them with a batch dataadapter.  For example:
//
//DataTable dtProducts = new DataTable()
//dtProducts.Columns.Add(ProductID) //yada yada all of the columns here
//
//DataTable dtCustomers = new DataTable()
//dtCustomers.Columns.Add(CustomerID) //yada yada all of the columns here


//foreach (insertItem in db.Inserts) //this is pseudo code, I need help here
//{
//   if (insertItem.destinationTable == "Products")
//   {
//      DataRow dr = dtProducts.NewRow();
//      dr["ProductID"] = insertItem.ProductID; //This line of code probably isn't even close to being right... I can't imagine the "insertItem" holding all of the columns no matter what the destinationTable is
//   }
//   if (insertItem.destinationTable == "Customers")
//   {
//       //similar code, all customer columns, yada yada
//   }
//   IMPORTANT: remove the item from the LINQ db so it doesn't insert it anymore
//
// Make a table adapter for each datatable
// Set the .BatchSize parameter
//Commit each table adapter.
// db.SubmitChanges()  //If there are any updates or deletes they are still in here and still need to happen.