Skip to main 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 6.0.0+8c7432e50072e009353ea5f2c956ccf453476f71

ToString() Method​

Gets a string representation of the table.

Declaration​

public string ToString()

Return value​

string The name of the table.

Columns Property​

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​

Gets the name of the table.

Declaration​

public string Name { get; set; }

PrimaryKeys Property​

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

Declaration​

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

SqlCreateString Property​

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

Declaration​

public string SqlCreateString { get; set; }

SqlInsertString Property​

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​

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 *".