Skip to content

ColumnInfo Class

Defines a single column of a table in an installer database.

Methods

MethodDescription
ToString()Gets the name of the column.

Properties

PropertyDescription
ColumnDefinitionStringGets a short string defining the type and size of the column.
DBTypeGets the type of the column as an integer that can be cast to a System.Data.DbType. This is one of the following: Int16, Int32, String, or Binary
IsLocalizableGets a value indicating whether the column is a string column that is localizable.
IsRequiredGets a value indicating whether the column must be non-null when inserting a record.
IsTemporaryGets a value indicating whether the column is temporary. Temporary columns are not persisted when the database is saved to disk.
NameGets the name of the column.
SizeGets the size of the column.
SqlCreateStringGets an SQL fragment that can be used to create this column within a CREATE TABLE statement.
TypeGets the type of the column as a System.Type. This is one of the following: Int16, Int32, String, or Stream

Remarks

Once created, a ColumnInfo object is immutable. WixToolset.Dtf.WindowsInstaller.dll version 5.0.0+41e11442b2ca93e444b60213b5ae99dcbab787d8

ToString() Method

Gets the name of the column.

Declaration

public string ToString()

Return value

string Name of the column.

ColumnDefinitionString Property

Gets a short string defining the type and size of the column.

Declaration

public string ColumnDefinitionString { get; set; }

Remarks

  • s? - String, variable length (?=1-255)
  • s0 - String, variable length
  • i2 - Short integer
  • i4 - Long integer
  • v0 - Binary Stream
  • g? - Temporary string (?=0-255)
  • j? - Temporary integer (?=0,1,2,4)
  • O0 - Temporary object (stream)
  • l? - Localizable string, variable length (?=1-255)
  • l0 - Localizable string, variable length

DBType Property

Gets the type of the column as an integer that can be cast to a System.Data.DbType. This is one of the following: Int16, Int32, String, or Binary

Declaration

public int DBType { get; set; }

IsLocalizable Property

Gets a value indicating whether the column is a string column that is localizable.

Declaration

public bool IsLocalizable { get; set; }

IsRequired Property

Gets a value indicating whether the column must be non-null when inserting a record.

Declaration

public bool IsRequired { get; set; }

IsTemporary Property

Gets a value indicating whether the column is temporary. Temporary columns are not persisted when the database is saved to disk.

Declaration

public bool IsTemporary { get; set; }

Name Property

Gets the name of the column.

Declaration

public string Name { get; set; }

Size Property

Gets the size of the column.

Declaration

public int Size { get; set; }

SqlCreateString Property

Gets an SQL fragment that can be used to create this column within a CREATE TABLE statement.

Declaration

public string SqlCreateString { get; set; }

Remarks

Examples:

  • LONG
  • SHORT TEMPORARY
  • CHAR(0) LOCALIZABLE
  • CHAR(72) NOT NULL LOCALIZABLE
  • OBJECT

Type Property

Gets the type of the column as a System.Type. This is one of the following: Int16, Int32, String, or Stream

Declaration

public System.Type Type { get; set; }