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;
}
}
