How to bulk insert / update in linq in sql?

How can I accomplish these 2 scenarios.

I am currently doing something like this

public class Repository
{
     private LinqtoSqlContext dbcontext = new LinqtoSqlContext();

   public void Update()
   {
   // find record
   // update record
   // save record ( dbcontext.submitChanges()
   }

   public void Insert()
   {
      // make a database table object ( ie ProductTable t = new ProductTable() { productname 
           ="something"}
      // insert record ( dbcontext.ProductTable.insertOnSubmit())
     // dbcontext.submitChanges();
   }
}

      

        
        
        
      

    

So now I am trying to load an XML file which has a lot of records. First, I check the entries one at a time. Then I want to insert them into the database, but instead of doing submitChanges () after each record, I want to make a massive gift at the end.

So I have something like this

public class Repository
{
    private LinqtoSqlContext dbcontext = new LinqtoSqlContext();
   public void Update()
   {
   // find record
   // update record
   }

   public void Insert()
   {
      // make a database table object ( ie ProductTable t = new ProductTable() { productname 
           ="something"}
      // insert record ( dbcontext.ProductTable.insertOnSubmit())
   }

   public void SaveToDb()
   {
      dbcontext.submitChanges();
   }
}

      

        
        
        
      

    

Then in my service layer I would like

for(int i = 0; i < 100; i++)
{
    validate();
    if(valid == true)
    {
       update();
       insert()
    }
}

SaveToDb();

      

        
        
        
      

    

So, pretend that my for loop has a count for the entire record found in the XML file. I check it first. If it is valid, I must update the table before inserting the record. Then I insert the entry.

After that, I want to save everything in one go.

I'm not sure if I can bulk save on refresh if it should be after every time or what.

But I thought it probably works for insert.

Nothing seems to crash and I'm not sure how to check if entries are being added to the dbcontext.