Skip to content

ColumnInfo Class

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

MethodDescription
ToString()Gets the name of the column.
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

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

Gets the name of the column.

public string ToString()

string Name of the column.

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

public string ColumnDefinitionString { get; set; }
  • 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

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

public int DBType { get; set; }

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

public bool IsLocalizable { get; set; }

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

public bool IsRequired { get; set; }

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

public bool IsTemporary { get; set; }

Gets the name of the column.

public string Name { get; set; }

Gets the size of the column.

public int Size { get; set; }

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

public string SqlCreateString { get; set; }

Examples:

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

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

public System.Type Type { get; set; }