public List <CommandResult> ADD_SCAFFOLD_DATA(IConnectToDB _Connect, string TableName) { List <CommandResult> HoldResult = new List <CommandResult>(); CommandResult _result = new CommandResult(); Tools.Box er_tools = new Tools.Box(); ER_Generate gen = new ER_Generate(); string newTableName = er_tools.MaxNameLength(TableName, (128 - 16)); string Char_Table = newTableName + "_Dat_Char"; string Date_Table = newTableName + "_Dat_Date"; string Number_Table = newTableName + "_Dat_Numb"; string File_Table = newTableName + "_Dat_File"; string Options_Table = newTableName + "_Dat_Opt"; string Decimal_Table = newTableName + "_Dat_Deci"; string Stages_Name = TableName + "_Stages"; HoldResult.Add(new CommandResult { _Successful = true, _Response = "---Start Data Scaffold " + TableName + "", _EndTime = DateTime.Now }); List <ColumnStructure> ColumnsList = new List <ColumnStructure>(); string[] tablesList = { Char_Table, Number_Table, Date_Table, File_Table, Options_Table, Decimal_Table }; foreach (var t in tablesList) { HoldResult.AddRange(ER_DDL._ADD_TABLE(_Connect, t, "Application Data")); } //ColumnsList.Add(new ColumnStructure { _Name = "RENDITION", _DataType = "bigint", _DefaultValue = "0", _IsNull = false }); HoldResult.AddRange(ER_DDL._ADD_TABLE_CHAR(_Connect, TableName, Char_Table, ColumnsList)); //ColumnsList.Add(new ColumnStructure { _Name = "RENDITION", _DataType = "bigint", _DefaultValue = "0", _IsNull = false }); HoldResult.AddRange(ER_DDL._ADD_TABLE_NUMB(_Connect, TableName, Number_Table, ColumnsList)); //ColumnsList.Add(new ColumnStructure { _Name = "RENDITION", _DataType = "bigint", _DefaultValue = "0", _IsNull = false }); HoldResult.AddRange(ER_DDL._ADD_TABLE_DATE(_Connect, TableName, Date_Table, ColumnsList)); //ColumnsList.Add(new ColumnStructure { _Name = "RENDITION", _DataType = "bigint", _DefaultValue = "0", _IsNull = false }); HoldResult.AddRange(ER_DDL._ADD_TABLE_FILE(_Connect, TableName, File_Table, ColumnsList)); //ColumnsList.Add(new ColumnStructure { _Name = "RENDITION", _DataType = "bigint", _DefaultValue = "0", _IsNull = false }); //HoldResult.AddRange(ER_DDL._ADD_TABLE_OPT(_Connect, TableName, Options_Table, ColumnsList)); //ColumnsList.Add(new ColumnStructure { _Name = "RENDITION", _DataType = "bigint", _DefaultValue = "0", _IsNull = false }); HoldResult.AddRange(ER_DDL._ADD_TABLE_DECIMAL(_Connect, TableName, Decimal_Table, ColumnsList)); foreach (var t in tablesList) { ColumnsList.Clear(); var item = new ColumnStructure { _Name = t + "_UUID", _DefaultValue = "", _IsNull = false, _DataType = "Guid" // t != Decimal_Table ? "bigint" : "Money"; }; ColumnsList.Add(item); HoldResult.AddRange(ER_DDL._ADD_INDEX_NONE_CLUSTERED(_Connect, t + "_CI", t, "TABLE", ColumnsList)); HoldResult.AddRange(gen.ADD_PROCEDURE_INSERT(_Connect, t, "")); } HoldResult.Add(new CommandResult { _Successful = true, _Response = "---End Data Scaffold " + TableName + "", _EndTime = DateTime.Now }); return(HoldResult); }