private int executeUpdate(SyncLogger logger, SyncRegionUpdate update) { logger.log(2, update.Statement); SQLiteCommand cmd = new SQLiteCommand(connection); cmd.CommandText = update.Statement; if (update.Executions == null) { return cmd.ExecuteNonQuery(); } else { int rowsAffected = 0; foreach (ParameterSet set in update.Executions) { logger.log(3, string.Join(",", set)); cmd.Parameters.Clear(); foreach (string param in set) { SQLiteParameter p = new SQLiteParameter(); p.Value = param; cmd.Parameters.Add(p); } rowsAffected += cmd.ExecuteNonQuery(); } return rowsAffected; } }
private int executeUpdate(SyncLogger logger, SyncRegionUpdate update) { logger.log(2, update.Statement); SQLiteCommand cmd = new SQLiteCommand(connection); cmd.CommandText = update.Statement; if (update.Executions == null) { return(cmd.ExecuteNonQuery()); } else { int rowsAffected = 0; foreach (ParameterSet set in update.Executions) { logger.log(3, string.Join(",", set)); cmd.Parameters.Clear(); foreach (string param in set) { SQLiteParameter p = new SQLiteParameter(); p.Value = param; cmd.Parameters.Add(p); } rowsAffected += cmd.ExecuteNonQuery(); } return(rowsAffected); } }