title: Insert multiple rows into sdf file database with one insert
body: <p>I have function to insert into my SQL Server CE database.</p>
  
  <pre><code>private void update_database(string SQL_string)
  {
          DBconnection.Open();
          SqlCeCommand SQL_querry = DBconnection.CreateCommand();
          SQL_querry.CommandText = SQL_string;
          SQL_querry.ExecuteNonQuery();
          DBconnection.Close();
  }
  </code></pre>
  
  <p>I'm passing to it <code>SQL</code> string calling</p>
  
  <pre><code>SQL_string = @"insert into Cities(City, destination, distance) values('liege','aberdeen','386'), ('liege','kassel','348');";
  update_database(SQL_string);
  </code></pre>
  
  <p>and it throws an exception:</p>
  
  <blockquote>
    <p>There was an error parsing the query. [ Token line number = 1,Token line offset = 81,Token in error = , ]"</p>
  </blockquote>
  
  <p>which clearly states, that problem is with comma after first set of values...
  What is the most confusing for me is that when passing this sql_string:</p>
  
  <pre><code>SQL_string = @"insert into Cities(City, destination, distance) values('liege','aberdeen','386');";
  </code></pre>
  
  <p>it works without any problem.</p>
  
  <p>Does <code>SqlCeCommand</code> accept multirow insertions? What am I missing here?</p>