private async Task ProcessRow(DataRow row) { var commandText = GetCommandText(row); var command = Connection.CreateCommand(); command.CommandText = commandText; WriteDebug(commandText); try { using (SqlDataReader reader = await command.ExecuteReaderAsync()) { WriteVerbose($"Remove-Rows: Delete {row.ToKeyValuePairList().ConcatAndWrap()} successfull."); } } catch (SqlException e) { WriteWarning(e.Message); throw; } }
private async Task ProcessRow(DataRow row) { var commandText = GetCommandText(row); var command = Connection.CreateCommand(); command.CommandText = commandText; WriteDebug(commandText); try { using (var reader = await command.ExecuteReaderAsync()) { WriteVerbose($"Merge-Rows: Upsert {row.ToKeyValuePairList().ConcatAndWrap()} successfull."); } } catch (SqlException e) { this.WriteError(e, ErrorCategory.WriteError); throw; } }