The ITableManager type exposes the following members.
Back to Top
Back to Top
Methods
| Name | Description | |
|---|---|---|
 | AddTableColumn |
Add column to specified table.
|
| AlterTableColumn |
Rename, retype or allow/not allow NULL values in column
|
| AlterTableColumnWithDefaultValue |
Alter table column with default value.
|
| ColumnExistsInView |
Checks if column name is unique in given view.
|
| CreateColumnIndexes |
Creates the table indexes.
|
| CreateTable(String, String) |
Creates specified table in database.
|
| CreateTable(String, String, Boolean) |
Creates specified table in database with specified primary key column with or without identity.
|
| CreateView |
Creates specified view in database for given data class.
|
| DeleteDataFromTable |
Deletes data from specified table.
|
| DeleteObject |
Removes view or stored procedure from database.
|
| DropColumnIndexes |
Drops the column indexes, returns the DataSet of indexes.
|
| DropDefaultConstraint |
Drops the default constraint.
|
| DropTable |
Drop specified table from database.
|
| DropTableColumn |
Remove column from specified table.
|
| DropView |
Drop specified view from database.
|
| ExecuteQuery |
Executes query and returns the results in a DataSet.
|
| GetCode |
Returns SQL code of specified view or stored procedure.
|
| GetColumnIndexes |
Returns the DataSet of column indexes.
|
| GetColumnInformation |
Returns DataSet with specfied table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue
|
| GetList |
Returns list of views or stored procedures.
|
| GetPKConstraintName |
Returns the name of the PK constraint.
|
| GetPrimaryKeyColumns |
Returns list of column names which represent primary keys of the specified database table.
Returns empty list if primary keys are not found.
|
| GetTablePKName |
Returns name of the primary key. If more columns in PK, names are separated by semicolon ";".
|
| GetTables |
Gets the tables in the database matching the condition
|
| GetValueString |
Returns the value string using the database culture.
|
| GetXmlSchema |
Returns XML schema for specified table.
|
| ChangeDBObjectOwner |
Changes database object owner.
|
| RecreatePKConstraint |
Drops the current PK constraint and creates new from given columns.
|
| RefreshView |
Refreshes specified view in database.
|
| RenameTable |
Changes name of the table with original name according to the new name.
|
| StoredProcedureExists |
Determines whether specified stored procedure exists or not.
|
| TableExists |
Determines whether specified DB table exists or not.
|
| ViewExists |
Determines whether specified DB view exists or not.
|
Properties
| Name | Description | |
|---|---|---|
 | ConnectionString |
Connection string name
|
| DatabaseCulture |
Database culture setting from the web.config.
|
| DatabaseName |
Gets database name.
|
| DatabaseServerName |
Gets database server name.
|
| DatabaseServerVersion |
Gets database server version.
|
| DatabaseSize |
Gets database size(including log size).
|
| DatabaseVersion |
Gets database version
|
| DisableDebug |
If true, the debug is disabled in this table manager
|
See Also