ITableManager Interface

Ensures management of database table and table column.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0

Syntax

public interface ITableManager

The ITableManager type exposes the following members.

Properties

	Name	Description
Public property	ConnectionString	Connection string name
Public property	DatabaseCulture	Database culture setting from the web.config.
Public property	DatabaseName	Gets database name.
Public property	DatabaseServerName	Gets database server name.
Public property	DatabaseServerVersion	Gets database server version.
Public property	DatabaseSize	Gets database size(including log size).
Public property	DatabaseVersion	Gets database version
Public property	DisableDebug	If true, the debug is disabled in this table manager

Methods

	Name	Description
Public method	AddTableColumn	Add column to specified table.
Public method	AlterProcedure	Alters specified procedure in database
Public method	AlterTableColumn	Rename, retype or allow/not allow NULL values in column
Public method	AlterTableColumnWithDefaultValue	Alter table column with default value.
Public method	AlterView	Creates specified view in database for given data class.
Public method	ColumnExistsInView	Checks if column name is unique in given view.
Public method	CreateColumnIndexes	Creates the table indexes.
Public method	CreateProcedure	Creates specified procedure in database
Public method	CreateTable(String, String)	Creates specified table in database.
Public method	CreateTable(String, String, Boolean)	Creates specified table in database with specified primary key column with or without identity.
Public method	CreateView	Creates specified view in database for given data class.
Public method	DeleteDataFromTable	Deletes data from specified table.
Public method	DeleteObject	Removes view or stored procedure from database.
Public method	DropColumnIndexes	Drops the column indexes, returns the DataSet of indexes.
Public method	DropDefaultConstraint	Drops the default constraint.
Public method	DropTable	Drop specified table from database.
Public method	DropTableColumn	Remove column from specified table.
Public method	DropView	Drop specified view from database.
Public method	ExecuteQuery	Executes query and returns the results in a DataSet.
Public method	GetCode	Returns SQL code of specified view or stored procedure.
Public method	GetColumnIndexes	Returns the DataSet of column indexes.
Public method	GetColumnInformation	Returns DataSet with specfied table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue
Public method	GetIndexes	Returns DataSet with indexes of the given object. Returns columns IndexName, DropScript, CreateScript
Public method	GetList	Returns list of views or stored procedures.
Public method	GetPKConstraintName	Returns the name of the PK constraint.
Public method	GetPrimaryKeyColumns	Returns list of column names which represent primary keys of the specified database table. Returns empty list if primary keys are not found.
Public method	GetTableDependencies	Gets list of object names which have foreign key constraint dependency.
Public method	GetTablePKName	Returns name of the primary key. If more columns in PK, names are separated by semicolon ";".
Public method	GetTables	Gets the tables in the database matching the condition
Public method	GetValueString	Returns the value string using the database culture.
Public method	GetXmlSchema	Returns XML schema for specified table.
Public method	ChangeDBObjectOwner	Changes database object owner.
Public method	RecreatePKConstraint	Drops the current PK constraint and creates new from given columns.
Public method	RefreshView	Refreshes specified view in database.
Public method	RenameTable	Changes name of the table with original name according to the new name.
Public method	StoredProcedureExists	Determines whether specified stored procedure exists or not.
Public method	TableExists	Determines whether specified DB table exists or not.
Public method	ViewExists	Determines whether specified DB view exists or not.