Skip to content

TableInfo Class

Defines a table in an installation database.

Methods

MethodDescription
ToString()Gets a string representation of the table.

Properties

PropertyDescription
ColumnsGets information about the columns in this table.
NameGets the name of the table.
PrimaryKeysGets the names of the columns that are primary keys of the table.
SqlCreateStringGets an SQL CREATE string that can be used to create the table.
SqlInsertStringGets an SQL INSERT string that can be used insert a new record into the table.
SqlSelectStringGets an SQL SELECT string that can be used to select all columns of the table.
WixToolset.Dtf.WindowsInstaller.dll version 5.0.0+41e11442b2ca93e444b60213b5ae99dcbab787d8

ToString() Method {#tostring_nop}

Gets a string representation of the table.

Declaration

public string ToString()

Return value

string The name of the table.

Columns Property {#columns}

Gets information about the columns in this table.

Declaration

public ColumnCollection Columns { get; set; }

Remarks

This property queries the database every time it is called, to ensure the returned values are up-to-date. For best performance, hold onto the returned collection if using it more than once.

Name Property {#name}

Gets the name of the table.

Declaration

public string Name { get; set; }

PrimaryKeys Property {#primarykeys}

Gets the names of the columns that are primary keys of the table.

Declaration

public IList<System.String> PrimaryKeys { get; set; }

SqlCreateString Property {#sqlcreatestring}

Gets an SQL CREATE string that can be used to create the table.

Declaration

public string SqlCreateString { get; set; }

SqlInsertString Property {#sqlinsertstring}

Gets an SQL INSERT string that can be used insert a new record into the table.

Declaration

public string SqlInsertString { get; set; }

Remarks

The values are expressed as question-mark tokens, to be supplied by the record.

SqlSelectString Property {#sqlselectstring}

Gets an SQL SELECT string that can be used to select all columns of the table.

Declaration

public string SqlSelectString { get; set; }

Remarks

The columns are listed explicitly in the SELECT string, as opposed to using “SELECT *”.