Skip to main 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; }