title: EF6 Insert multiple rows in single query possibility
body: <p>Why EF <code>SaveChanges</code> is going to insert/delete each record in a separate query?</p>
  
  <p>Suppose this code:</p>
  
  <pre><code>using (var db = new AppEntities())
  {
      using (var transaction = db.Database.BeginTransaction(System.Data.IsolationLevel.Serializable))
      {
          try
          {
              db.Table1.AddRange(list);
              db.Table2.RemoveRange(list);
          }
          db.SaveChanges();
          transaction.Commit();
      }
  }
  </code></pre>
  
  <p>I check these lines with SQL Server Profiler, and surprisingly there is one <code>INSERT INTO</code> per each record! And worse than that, the same was for delete! This is not a serious problem for 100 rows. But with 5000 rows it takes 2 minutes!</p>
  
  <p><strong>Is it possible</strong> to tell EF, <em>PLEASE</em> do this in following way :</p>
  
  <pre><code>INSERT INTO TABLE1 VALUES (),(),(),();
  </code></pre>