title: bulk insert with linq-to-sql
body: <p>I have a query that looks like this:</p>
  
  <pre><code>using (MyDC TheDC = new MyDC())
  {
     foreach (MyObject TheObject in TheListOfMyObjects)
     {
        DBTable TheTable = new DBTable();
  
        TheTable.Prop1 = TheObject.Prop1;
        .....
        TheDC.DBTables.InsertOnSubmit(TheTable);
  
     }
     TheDC.SubmitChanges();
  }
  </code></pre>
  
  <p>This query basically inserts a list into the database using linq-to-sql. Now I've read online that L2S does NOT support bulk operations.
  Does my query work by inserting each element at a time or all of them in one write?</p>
  
  <p>Thanks for the clarification.</p>