Class TableColumn

A column in table

Inheritance

object

TableColumn

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.ControlFlow

Assembly: ETLBox.dll

Syntax

    public class TableColumn

Constructors

TableColumn()

Declaration

    public TableColumn()

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

Declaration

    public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey, bool isIdentity)

Parameters

Type	Name	Description
string	name
string	dataType
bool	allowNulls
bool	isPrimaryKey
bool	isIdentity

TableColumn(string, string, bool, bool)

Declaration

    public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey)

Parameters

Type	Name	Description
string	name
string	dataType
bool	allowNulls
bool	isPrimaryKey

TableColumn(string, string, bool)

Declaration

    public TableColumn(string name, string dataType, bool allowNulls)

Parameters

Type	Name	Description
string	name
string	dataType
bool	allowNulls

TableColumn(string, string)

Declaration

    public TableColumn(string name, string dataType)

Parameters

Type	Name	Description
string	name
string	dataType

TableColumn(string)

Declaration

    public TableColumn(string name)

Parameters

Type	Name	Description
string	name

Properties

AllowNulls

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

Declaration

    public bool AllowNulls { get; set; }

Property Value

Type	Description
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

Type	Description
string

Comment

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

Declaration

    public string Comment { get; set; }

Property Value

Type	Description
string

ComputedColumn

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

Declaration

    public string ComputedColumn { get; set; }

Property Value

Type	Description
string

DataType

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

Declaration

    public string DataType { get; set; }

Property Value

Type	Description
string

DefaultValue

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

Declaration

    public string DefaultValue { get; set; }

Property Value

Type	Description
string

IdentityIncrement

Only SqlServer: The increment value for an identity column

Declaration

    public int? IdentityIncrement { get; set; }

Property Value

Type	Description
int?

IdentitySeed

Only SqlServer: The seed for and identity column

Declaration

    public int? IdentitySeed { get; set; }

Property Value

Type	Description
int?

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

Type	Description
bool

IsPrimaryKey

True if the column is part of the primary key

Declaration

    public bool IsPrimaryKey { get; set; }

Property Value

Type	Description
bool

Name

Name of the column

Declaration

    public string Name { get; set; }

Property Value

Type	Description
string

NETDataType

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

Declaration

    public Type NETDataType { get; }

Property Value

Type	Description
System.Type