title: Trying to update SQL Server CE failing
body: <p>I have the insert working fine with my SQL Server CE database however I am struggling to update.</p>
  
  <p>Can anyone see whats wrong with what I am trying </p>
  
  <pre><code>using (SqlCeConnection con = new SqlCeConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
  {
      con.Open();
      // Insert into the SqlCe table. ExecuteNonQuery is best for inserts.
      string sql = "UPDATE SalesAssistant SET "
            + "(Name=@Name,IsEnabled=@IsEnabled,Role=@Role,LastModifiedDate=@LastModifiedDate,IsAdministrator=@IsAdministrator,PIN=@PIN,IsDeleted=@IsDeleted)" +
            "WHERE SalesAssistantID=@SalesAssistantID";
  
      using (SqlCeCommand com = new SqlCeCommand(sql, con))
      {
          com.Parameters.AddWithValue("@SalesAssistantID", em.ServerData.EmployeeID);
          com.Parameters.AddWithValue("@Name", em.ServerData.EmployeeName);
          com.Parameters.AddWithValue("@IsEnabled", em.ServerData.IsEnabled);
          com.Parameters.AddWithValue("@LastModifiedDate", em.ServerData.LastModifiedDate);
          com.Parameters.AddWithValue("@IsAdministrator", em.ServerData.IsAdministrator);
          com.Parameters.AddWithValue("@IsDeleted", em.ServerData.IsDeleted);
          com.Parameters.AddWithValue("@Role", em.ServerData.Role);
          com.Parameters.AddWithValue("@PIN", em.ServerData.PIN);
          com.ExecuteNonQuery();
      }
  }
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>There was an error parsing the query. [ Token line number = 1,Token line offset = 27,Token in error = ( ]</p>
  </blockquote>