protected InsertSections GetTableInsert(TableKey table)
{
InsertSections result = null;
if (_tableToInsertStatments.TryGetValue(table, out result))
{
return(result);
}
result = new InsertSections( );
result.InsertTemplate = SqlInsertStatments.GetInsertIntoTable(table);
result.TableName = table.Name;
_tableToInsertStatments.Add(table, result);
return(result);
}
protected virtual string GetInsertText()
{
StringBuilder result = new StringBuilder(SqlInsertStatments.BeginTransaction);
result.AppendLine( );
foreach (var insertKeyValue in _tableToInsertStatments)
{
var insert = insertKeyValue.Value;
string columns = string.Join(", ", insert.ColumnNames);
string values = string.Join(", ", insert.ParametersValueNames);
result.AppendLine(SqlInsertStatments.GetTablesKey(insertKeyValue.Key));
result.AppendFormat(insert.InsertTemplate, columns, values);
result.AppendLine( );
}
result.AppendLine(SqlInsertStatments.CommitTransaction);
return(result.ToString( ));
}
