DbColumnInfo

Ecng.Data

Represents column metadata read from a live database.

Constructors

public DbColumnInfo(string TableName, string ColumnName, string DataType, bool IsNullable, int? MaxLength, int? NumericPrecision, int? NumericScale, bool IsComputed)

dbColumnInfo = DbColumnInfo(TableName, ColumnName, DataType, IsNullable, MaxLength, NumericPrecision, NumericScale, IsComputed)

Represents column metadata read from a live database.

TableName: The table name.
ColumnName: The column name.
DataType: SQL data type name (e.g. "nvarchar", "bigint").
IsNullable: Whether the column allows NULLs.
MaxLength: Max character length for string columns, or null.
NumericPrecision: Numeric precision, or the fractional-second digits of a date/time column; null when the column has neither.
NumericScale: Numeric scale, or null.
IsComputed: Whether the column is computed (calculated).

Properties

ColumnName

public string ColumnName { get; set; }

value = dbColumnInfo.ColumnName
dbColumnInfo.ColumnName = value

The column name.

DataType

public string DataType { get; set; }

value = dbColumnInfo.DataType
dbColumnInfo.DataType = value

SQL data type name (e.g. "nvarchar", "bigint").

IsComputed

public bool IsComputed { get; set; }

value = dbColumnInfo.IsComputed
dbColumnInfo.IsComputed = value

Whether the column is computed (calculated).

IsNullable

public bool IsNullable { get; set; }

value = dbColumnInfo.IsNullable
dbColumnInfo.IsNullable = value

Whether the column allows NULLs.

MaxLength

public int? MaxLength { get; set; }

value = dbColumnInfo.MaxLength
dbColumnInfo.MaxLength = value

Max character length for string columns, or null.

NumericPrecision

public int? NumericPrecision { get; set; }

value = dbColumnInfo.NumericPrecision
dbColumnInfo.NumericPrecision = value

Numeric precision, or the fractional-second digits of a date/time column; null when the column has neither.

NumericScale

public int? NumericScale { get; set; }

value = dbColumnInfo.NumericScale
dbColumnInfo.NumericScale = value

Numeric scale, or null.

TableName

public string TableName { get; set; }

value = dbColumnInfo.TableName
dbColumnInfo.TableName = value

The table name.