private void SqlDeleteIds(IEnumerable <TInput> rowsToDelete)
{
if (rowsToDelete.Count() == 0)
{
return;
}
var deleteString = rowsToDelete.Select(row => $"'{GetUniqueId(row)}'");
string idNames = $"{QB}{IdColumnNames.First()}{QE}";
if (IdColumnNames.Count > 1)
{
idNames = CreateConcatSqlForNames();
}
var sql = new SqlTask($@"
DELETE FROM {TN.QuotatedFullName}
WHERE {idNames} IN (
{String.Join(",", deleteString)}
)")
{
DisableLogging = true,
ConnectionManager = this.ConnectionManager
};
sql.CopyLogTaskProperties(this);
sql.ExecuteNonQuery();
}
private SqlTask CreateSqlTask(string sql)
{
var sqlT = new SqlTask(sql)
{
DisableLogging = true,
ConnectionManager = this.ConnectionManager
};
sqlT.CopyLogTaskProperties(this);
sqlT.Actions = new List <Action <object> >();
return(sqlT);
}
protected override void BulkInsertData(TInput[] data)
{
AddDynamicColumnsToTableDef(data);
TableData.ClearData();
ConvertAndAddRows(data);
var sql = new SqlTask($"Execute Bulk insert")
{
DisableLogging = true,
ConnectionManager = BulkInsertConnectionManager
};
sql.CopyLogTaskProperties(this);
sql
.BulkInsert(TableData, DestinationTableDefinition.Name);
BulkInsertConnectionManager.CheckLicenseOrThrow(ProgressCount);
}