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