/// <summary> /// Creates a CREATE command from the table class template. Uses the first int column as primary key. /// </summary> public BuiltCreateCommand() { _tableName = SqlTableHelper.GetTableName <T>(); _columns = SqlTableHelper.GetColumnAttributes <T>(); if (_columns.Count == 0) { throw new Exception("Can't create empty table."); } }
/// <summary> /// Creates a new value list using all columns from the table. /// </summary> public BuiltValueList() { _columnAttributes = SqlTableHelper.GetColumnAttributes <T>(); foreach (var column in _columnAttributes) { _columnsWithValues.Add(new ColumnWithValue { Column = column.ColumnName, Value = "", ValueType = column.Type }); } }
/// <summary> /// Creates a new value list using the specified columns. /// </summary> public BuiltValueList(List <string> columns) { _columnAttributes = SqlTableHelper.GetColumnAttributes <T>(); foreach (var col in columns) { SqlColumn columnAttribute = _columnAttributes.FirstOrDefault(attr => attr.ColumnName == col); if (columnAttribute == null) { throw new Exception($"Table \"{typeof(T).FullName}\" does not contain a column named \"{col}\""); } _columnsWithValues.Add(new ColumnWithValue { Column = col, Value = "", ValueType = columnAttribute.Type }); } }