AbstractTableManager Class

Ensures management of database table and table column.

Inheritance Hierarchy

System.Object
  CMS.DataEngine.AbstractTableManager
    CMS.DataProviderSQL.TableManager

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

Syntax

public abstract class AbstractTableManager : ITableManager

The AbstractTableManager type exposes the following members.

Constructors

	Name	Description
Protected method	AbstractTableManager

Fields

	Name	Description
Protected field	mDatabaseCulture	Database culture setting from the web.config.

Properties

	Name	Description
Public property	ConnectionString	Connection string to use for table management
Public property	DatabaseCulture	Database culture setting from the web.config.
Public property	DatabaseName	Database name.
Public property	DatabaseServerName	Name of database server.
Public property	DatabaseServerVersion	Version of database server.
Public property	DatabaseSize	Database size(including log size) in MB.
Public property	DatabaseVersion	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	Alter table column with default value.
Public method	AlterView	Alters specified view in database
Public method	ChangeDBObjectOwner	Changes database object owner.
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.
Protected method	CreateTransactionScope	Returns a transaction scope that can be used to maintain database consistency.
Public method	CreateView	Creates specified view in database
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. Returns the schema of the dropped view
Protected method	EnsureDefaultValue	Add apostrophes around the column default value string according to column type.
Public method	ExecuteQuery	Executes query and returns the results in a DataSet.
Public method	ExecuteScalar	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 specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue.
Protected method	GetConnection	Gets the connection for the table management
Public method Static member	GetConstraintName	Returns constraint's name truncated to 128 chars (128 chars is limit of database column name).
Protected method	GetDatabaseInfo	Gets size related information about the database.
Protected method	GetDatabaseSize	Gets database size (including log size) or N/A string if the size cannot be retrieved
Protected method	GetDatabaseVersion	Gets the database version
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 primary key 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 current database
Public method	GetValueString	Returns the value string using the database culture. Does not include apostrophes for types that need them
Public method	GetXmlSchema	Returns XML schema for specified table.
Public method	RecreatePKConstraint	Drops the current primary key constraint and creates new from given columns.
Public method	RefreshView	Refreshes specified view in database.
Protected method	RenameColumn	Changes name of the column.
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(String)	Determines whether specified DB view exists or not.
Public method	ViewExists(String, String)	Determines whether specified DB view exists or not.