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