ITableCreator

Assembly: Cubes;

Namespace: Prognoz.Platform.Interop.Cubes;

Description

The ITableCreator interface contains properties and methods that are used for automatic creation of repository tables.

Inheritance Hierarchy

ITableCreator

Comments

To create a table:

• Initialize object of the TableCreator class.

• Select the database, in which the table is created, in the Database property.

• Specify the source on the basis of a structure and data, on which the table is formed in the Source property.

• Specify the information about the created repository table in the ObjectCreateInfo property.

• Call the Execute method.

A table is created in the repository according to the ObjectCreateInfo information, and the structure similar to the structure of the Source data source after specifying all the parameters and calling the Execute method. The corresponding physical table is also created on the database server, which settings are specified in the Database database. All the data from the selected source is loaded to the table.

To limit the data loading, specify the DataRow and RowCount properties.

Properties

	Property name	Brief description
	Connection	The Connection property determines a binding, in which the queries of tables creation and data load are executed.
	Database	The Database property determines a database, in which a table is created.
	DataRow	The DataRow property determines a row index in the data source, which is the starting point to load the data to the table.
	Fields	The Fields property returns the collection of data source fields, based on which table fields are created.
	ObjectCreateInfo	The ObjectCreateInfo property determines description of the repository object that corresponds to the created table.
	RowCount	The RowCount property determines the number of data rows, which must be loaded to the created table.
	SkipEmptyRows	The SkipEmptyRows property determines the attribute of skipping empty rows.
	Source	The Source property determines the source, based on which the table is created.

Methods

	Method name	Brief description
	AddConverter	The AddConverter method transforms values of the specified field.
	Execute	The Execute method creates a table and loads data into it.

See also:

Cubes Assembly Interfaces