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

{{< /rawhtml >}} ```C# public class TableColumn ``` {{< rawhtml >}}

Constructors

TableColumn()

Declaration

{{< /rawhtml >}} ```C# public TableColumn() ``` {{< rawhtml >}}

TableColumn(string)

Declaration

{{< /rawhtml >}} ```C# public TableColumn(string name) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	name

TableColumn(string, string)

Declaration

{{< /rawhtml >}} ```C# public TableColumn(string name, string dataType) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	name
string	dataType

TableColumn(string, string, bool)

Declaration

{{< /rawhtml >}} ```C# public TableColumn(string name, string dataType, bool allowNulls) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	name
string	dataType
bool	allowNulls

TableColumn(string, string, bool, bool)

Declaration

{{< /rawhtml >}} ```C# public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	name
string	dataType
bool	allowNulls
bool	isPrimaryKey

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

Declaration

{{< /rawhtml >}} ```C# public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey, bool isIdentity) ``` {{< rawhtml >}}

Parameters

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

Properties

AllowNulls

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

Declaration

{{< /rawhtml >}} ```C# public bool AllowNulls { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

Collation

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

Declaration

{{< /rawhtml >}} ```C# public string Collation { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Comment

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

Declaration

{{< /rawhtml >}} ```C# public string Comment { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

ComputedColumn

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

Declaration

{{< /rawhtml >}} ```C# public string ComputedColumn { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

DataType

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

Declaration

{{< /rawhtml >}} ```C# public string DataType { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

DefaultValue

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

Declaration

{{< /rawhtml >}} ```C# public string DefaultValue { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

HasDefaultValue

Declaration

{{< /rawhtml >}} ```C# public bool HasDefaultValue { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

IdentityIncrement

Only SqlServer: The increment value for an identity column

Declaration

{{< /rawhtml >}} ```C# public long? IdentityIncrement { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
long?

IdentitySeed

Only SqlServer: The seed for and identity column

Declaration

{{< /rawhtml >}} ```C# public long? IdentitySeed { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
long?

IsComputed

Declaration

{{< /rawhtml >}} ```C# public bool IsComputed { get; } ``` {{< rawhtml >}}

Property Value

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

{{< /rawhtml >}} ```C# public bool IsIdentity { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

IsPrimaryKey

True if the column is part of the primary key

Declaration

{{< /rawhtml >}} ```C# public bool IsPrimaryKey { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

NETDataType

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

Declaration

{{< /rawhtml >}} ```C# public Type NETDataType { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
Type

Name

Name of the column

Declaration

{{< /rawhtml >}} ```C# public string Name { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string