public int Write(List <List <string> > linesToWrite) { Log.Debug($"SqlServerWriter: Write; Count='{linesToWrite.Count}'"); // insert var insertStatement = GetInsertStatements(linesToWrite); sqlServerService.simpleExecQuery(insertStatement, ImportTask.retryPolicyNumRetries, ImportTask.retryPolicyDelayRetries); return(0); }
public void Init(ImportFileOptions importTask, List <string> headers) { ImportTask = importTask; Headers = headers; Log.Debug($"SqlServerWriter: init for '{ImportTask.file}'"); sqlCmdBuilder = new SqlCmdBuilder(importTask); HeaderFields = sqlCmdBuilder.GetHeaderFields(Headers); sqlServerService = new SqlServerService(Log, getSqlConnectionString()); // Drop table sqlServerService.simpleExecQuery(GetDropTableStatement()); // Create table sqlServerService.simpleExecQuery(GetCreateTableStatement()); // Truncate Table sqlServerService.simpleExecQuery(GetTruncateTableStatement()); }