private void AppendBeginSql() { QueryText.AppendLine($@"INSERT INTO {TN.QuotatedFullName} ({string.Join(",", SourceColumnNames.Select(col => QB + col + QE))})"); if (IsAccessDatabase) { QueryText.AppendLine(" SELECT * FROM ("); } else if (ConnectionType == ConnectionManagerType.Oracle) { QueryText.AppendLine($" SELECT {string.Join(",", SourceColumnNames.Select(col => QB + col + QE))} FROM ("); } else { QueryText.AppendLine("VALUES"); } }
private void AppendBeginSql(string tableName) { QueryText.AppendLine($@"INSERT INTO {TN.QuotatedFullName} ({string.Join(",", SourceColumnNames.Select(col => QB + col + QE))})"); if (IsAccessDatabase) { QueryText.AppendLine(" SELECT * FROM ("); } else { QueryText.AppendLine("VALUES"); } }