Click or drag to resize
AbstractTableManager Class
Ensures management of database table and table column.
Inheritance Hierarchy

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0
Syntax
C#
public abstract class AbstractTableManager : ITableManager

The AbstractTableManager type exposes the following members.

Constructors
  NameDescription
Protected methodAbstractTableManager
Top
Fields
  NameDescription
Protected fieldmDatabaseCulture
Database culture setting from the web.config.
Top
Properties
  NameDescription
Public propertyConnectionString
Connection string to use for table management
Public propertyDatabaseCulture
Database culture setting from the web.config.
Public propertyDatabaseName
Database name.
Public propertyDatabaseServerName
Name of database server.
Public propertyDatabaseServerVersion
Version of database server.
Public propertyDatabaseSize
Database size(including log size) in MB.
Public propertyDatabaseVersion
Database version
Public propertyDisableDebug
If true, the debug is disabled in this table manager
Top
Methods
  NameDescription
Public methodAddTableColumn
Add column to specified table.
Public methodAlterProcedure
Alters specified procedure in database
Public methodAlterTableColumn
Alter table column with default value.
Public methodAlterView
Alters specified view in database
Public methodChangeDBObjectOwner
Changes database object owner.
Public methodColumnExistsInView
Checks if column name is unique in given view.
Public methodCreateColumnIndexes
Creates the table indexes.
Public methodCreateProcedure
Creates specified procedure in database
Public methodCreateTable(String, String)
Creates specified table in database.
Public methodCreateTable(String, String, Boolean)
Creates specified table in database.
Protected methodCreateTransactionScope
Returns a transaction scope that can be used to maintain database consistency.
Public methodCreateView
Creates specified view in database
Public methodDeleteDataFromTable
Deletes data from specified table.
Public methodDeleteObject
Removes view or stored procedure from database.
Public methodDropColumnIndexes
Drops the column indexes, returns the DataSet of indexes.
Public methodDropDefaultConstraint
Drops the default constraint.
Public methodDropTable
Drop specified table from database.
Public methodDropTableColumn
Remove column from specified table.
Public methodDropView
Drop specified view from database. Returns the schema of the dropped view
Protected methodEnsureDefaultValue
Add apostrophes around the column default value string according to column type.
Public methodExecuteQuery
Executes query and returns the results in a DataSet.
Public methodExecuteScalar
Executes query and returns the results in a DataSet.
Public methodGetCode
Returns SQL code of specified view or stored procedure.
Public methodGetColumnIndexes
Returns the DataSet of column indexes.
Public methodGetColumnInformation
Returns DataSet with specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue.
Protected methodGetConnection
Gets the connection for the table management
Public methodStatic memberGetConstraintName
Returns constraint's name truncated to 128 chars (128 chars is limit of database column name).
Protected methodGetDatabaseInfo
Gets size related information about the database.
Protected methodGetDatabaseSize
Gets database size (including log size) or N/A string if the size cannot be retrieved
Protected methodGetDatabaseVersion
Gets the database version
Public methodGetIndexes
Returns DataSet with indexes of the given object. Returns columns IndexName, DropScript, CreateScript
Public methodGetList
Returns list of views or stored procedures.
Public methodGetPKConstraintName
Returns the name of the primary key constraint.
Public methodGetPrimaryKeyColumns
Returns list of column names which represent primary keys of the specified database table. Returns empty list if primary keys are not found.
Public methodGetTableDependencies
Gets list of object names which have foreign key constraint dependency.
Public methodGetTablePKName
Returns name of the primary key. If more columns in PK, names are separated by semicolon ";".
Public methodGetTables
Gets the tables in the current database
Public methodGetValueString
Returns the value string using the database culture. Does not include apostrophes for types that need them
Public methodGetXmlSchema
Returns XML schema for specified table.
Public methodRecreatePKConstraint
Drops the current primary key constraint and creates new from given columns.
Public methodRefreshView
Refreshes specified view in database.
Protected methodRenameColumn
Changes name of the column.
Public methodRenameTable
Changes name of the table with original name according to the new name.
Public methodStoredProcedureExists
Determines whether specified stored procedure exists or not.
Public methodTableExists
Determines whether specified DB table exists or not.
Public methodViewExists(String)
Determines whether specified DB view exists or not.
Public methodViewExists(String, String)
Determines whether specified DB view exists or not.
Top
See Also