title: Inserting multiple rows in Webmatrix database
body: <p>I'm sure this is a comparatively simple question, but after several hours, I haven't been able to find the answer, and I'm still somewhat new to the wonderful world of databasing.</p>
  
  <p>I'm starting to use Webmatrix and I'm trying to import a database with 13 columns and a little over 200 rows (just enough so I don't want to type it all out again). </p>
  
  <p>All my work remains offline and won't go online for at least another few months. So far I have worked on a Mac (php, mysql,etc) and just switched to PC to try Webmatrix. Since I couldn't find a simple enough feature to import a database in Webmatrix, I figured the easiest way might be to export an SQL file from phpMyAdmin on my Mac and execute it once via a cshtml page (coding razor).</p>
  
  <p>With a few adjustments I recreated my table in this way and I'm also able to insert values in individual rows, however, I can't seem to be able to insert more than one row at a time.</p>
  
  <p>My intended code is basically:</p>
  
  <pre><code>var db = Database.Open("Database");
  var insertQuery = "INSERT INTO table (field1, field2, field3) VALUES ('val1', 'val2', 'val3'),('val4','val5','val6'),(etc)";
  db.Execute(insertQuery);
  </code></pre>
  
  <p>Could anyone shed some light on what might be going wrong here?
  I also looked at other methods of importing databases, I read about MySQL benchmark, but admit that's going a bit over my head.</p>
  
  <p>Thanks in advance.</p>