TableColumn

Class TableColumn

A column in table

Inheritance
TableColumn
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public class TableColumn

Constructors

TableColumn()

Declaration
    public TableColumn()

TableColumn(string)

Declaration
    public TableColumn(string name)
Parameters
TypeNameDescription
stringname

TableColumn(string, string)

Declaration
    public TableColumn(string name, string dataType)
Parameters
TypeNameDescription
stringname
stringdataType

TableColumn(string, string, bool)

Declaration
    public TableColumn(string name, string dataType, bool allowNulls)
Parameters
TypeNameDescription
stringname
stringdataType
boolallowNulls

TableColumn(string, string, bool, bool)

Declaration
    public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey)
Parameters
TypeNameDescription
stringname
stringdataType
boolallowNulls
boolisPrimaryKey

TableColumn(string, string, bool, bool, bool)

Declaration
    public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey, bool isIdentity)
Parameters
TypeNameDescription
stringname
stringdataType
boolallowNulls
boolisPrimaryKey
boolisIdentity

Properties

AllowNulls

True, if the column is nullable. By default a column is not nullable.

Declaration
    public bool AllowNulls { get; set; }
Property Value
TypeDescription
bool

Collation

The collation used for the column. Leave empty if you want to use the default collation.

Declaration
    public string Collation { get; set; }
Property Value
TypeDescription
string

Comment

A comment for the column (not supported by every database)

Declaration
    public string Comment { get; set; }
Property Value
TypeDescription
string

ComputedColumn

The calculation if the column should be computed. Not all databases may support this.

Declaration
    public string ComputedColumn { get; set; }
Property Value
TypeDescription
string

DataType

The sql data type of the column (e.g. "INT" or "VARCHAR(30)")

Declaration
    public string DataType { get; set; }
Property Value
TypeDescription
string

DefaultValue

Define a default value for the column. Not all databases may support this.

Declaration
    public string DefaultValue { get; set; }
Property Value
TypeDescription
string

IdentityIncrement

Only SqlServer: The increment value for an identity column

Declaration
    public long? IdentityIncrement { get; set; }
Property Value
TypeDescription
long?

IdentitySeed

Only SqlServer: The seed for and identity column

Declaration
    public long? IdentitySeed { get; set; }
Property Value
TypeDescription
long?

IsComputed

Declaration
    public bool IsComputed { get; }
Property Value
TypeDescription
bool

IsIdentity

True, if the column is used as an Identity column (auto increment in MySql or serial in Postgres) Not every database supports this.

Declaration
    public bool IsIdentity { get; set; }
Property Value
TypeDescription
bool

IsPrimaryKey

True if the column is part of the primary key

Declaration
    public bool IsPrimaryKey { get; set; }
Property Value
TypeDescription
bool

NETDataType

The corresponding .NET data type retrieved from the sql DataType.

Declaration
    public Type NETDataType { get; }
Property Value
TypeDescription
Type

Name

Name of the column

Declaration
    public string Name { get; set; }
Property Value
TypeDescription
string