private static string GetInsertStatements(AstTableNode table, AstTableStaticSourceNode staticSource)
{
var staticSourceEmitter = new StaticSourceTSqlEmitter(table);
foreach (AstStaticSourceRowNode row in staticSource.Rows)
{
foreach (AstStaticSourceColumnValueNode columnValue in row.ColumnValues)
{
staticSourceEmitter.AddDefaultValue(columnValue.Column.Name, columnValue.Value);
}
staticSourceEmitter.CompleteRow();
}
return staticSourceEmitter.Emit();
}
public static AstExecuteSqlTaskNode CreateInsertExecuteSql(AstTableStaticSourceNode staticSource, IFrameworkItem insertParent, AstTableNode insertTargetTable)
{
var executeSql = new AstExecuteSqlTaskNode(insertParent)
{
Connection = insertTargetTable.Connection,
ExecuteDuringDesignTime = false,
Name = Utility.NameCleanerAndUniqifier(insertTargetTable + "_Insert"),
};
executeSql.Query = new AstExecuteSqlQueryNode(executeSql)
{
Body = GetInsertStatements(insertTargetTable, staticSource),
QueryType = QueryType.Standard
};
return executeSql;
}
