ETLBox ETLBox

Class TableColumn

A column in table

Inheritance
System.Object
TableColumn
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public class TableColumn

Constructors

TableColumn()

Declaration
    public TableColumn()

TableColumn(String, String)

Declaration
    public TableColumn(string name, string dataType)
Parameters
TypeNameDescription
System.Stringname
System.StringdataType

TableColumn(String, String, Boolean)

Declaration
    public TableColumn(string name, string dataType, bool allowNulls)
Parameters
TypeNameDescription
System.Stringname
System.StringdataType
System.BooleanallowNulls

TableColumn(String, String, Boolean, Boolean)

Declaration
    public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey)
Parameters
TypeNameDescription
System.Stringname
System.StringdataType
System.BooleanallowNulls
System.BooleanisPrimaryKey

TableColumn(String, String, Boolean, Boolean, Boolean)

Declaration
    public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey, bool isIdentity)
Parameters
TypeNameDescription
System.Stringname
System.StringdataType
System.BooleanallowNulls
System.BooleanisPrimaryKey
System.BooleanisIdentity

Properties

AllowNulls

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

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

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
System.String

Comment

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

Declaration
    public string Comment { get; set; }
Property Value
TypeDescription
System.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
System.String

DataType

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

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

DefaultValue

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

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

IdentityIncrement

Only SqlServer: The increment value for an identity column

Declaration
    public int? IdentityIncrement { get; set; }
Property Value
TypeDescription
System.Nullable<System.Int32>

IdentitySeed

Only SqlServer: The seed for and identity column

Declaration
    public int? IdentitySeed { get; set; }
Property Value
TypeDescription
System.Nullable<System.Int32>

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
System.Boolean

IsPrimaryKey

True if the column is part of the primary key

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

IsUnique

The column is part of a unique constraint

Declaration
    public bool IsUnique { get; set; }
Property Value
TypeDescription
System.Boolean

Name

Name of the column

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

NETDataType

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

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