The TableManager type exposes the following members.
Back to Top
Back to Top
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | TableManager |
Methods
| Name | Description | |
|---|---|---|
| AddTableColumn |
Add column to specified table.
(Inherited from AbstractTableManager.) |
| AlterTableColumn |
Rename, retype or allow/not allow NULL values in column
(Inherited from AbstractTableManager.) |
| AlterTableColumnWithDefaultValue |
Alter table column with default value.
(Inherited from AbstractTableManager.) |
| ColumnExistsInView |
Checks if column name is unique in given view.
(Inherited from AbstractTableManager.) |
| CreateColumnIndexes |
Creates the table indexes.
(Inherited from AbstractTableManager.) |
| CreateTable(String, String) |
Creates specified table in database.
(Inherited from AbstractTableManager.) |
| CreateTable(String, String, Boolean) |
Creates specified table in database.
(Inherited from AbstractTableManager.) |
| CreateView |
Creates specified view in database for given data class.
(Inherited from AbstractTableManager.) |
| DeleteDataFromTable |
Deletes data from specified table.
(Inherited from AbstractTableManager.) |
| DeleteObject |
Removes view or stored procedure from database.
(Inherited from AbstractTableManager.) |
| DropColumnIndexes |
Drops the column indexes, returns the DataSet of indexes.
(Inherited from AbstractTableManager.) |
| DropDefaultConstraint |
Drops the default constraint.
(Inherited from AbstractTableManager.) |
| DropTable |
Drop specified table from database.
(Inherited from AbstractTableManager.) |
| DropTableColumn |
Remove column from specified table.
(Inherited from AbstractTableManager.) |
| DropView |
Drop specified view from database. Returns the schema of the dropped view
(Inherited from AbstractTableManager.) |
 | EnsureDefaultValue |
Add apostrophes around the column default value string according to column type.
(Inherited from AbstractTableManager.) |
|  Equals | (Inherited from Object.) |
| ExecuteQuery |
Executes query and returns the results in a DataSet.
(Inherited from AbstractTableManager.) |
| ExecuteScalar |
Executes query and returns the results in a DataSet.
(Inherited from AbstractTableManager.) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetCode |
Returns SQL code of specified view or stored procedure.
(Inherited from AbstractTableManager.) |
| GetColumnIndexes |
Returns the DataSet of column indexes.
(Inherited from AbstractTableManager.) |
| GetColumnInformation |
Returns DataSet with specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue
(Inherited from AbstractTableManager.) |
| GetConnection |
Gets the connection for the table management
(Inherited from AbstractTableManager.) |
| GetDatabaseInfo |
Gets size related information about the database.
(Inherited from AbstractTableManager.) |
| GetDatabaseSize |
Gets database size (including log size) or N/A string if the size cannot be retrieved
(Inherited from AbstractTableManager.) |
| GetDatabaseVersion |
Gets the database version
(Inherited from AbstractTableManager.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetList |
Returns list of views or stored procedures.
(Inherited from AbstractTableManager.) |
| GetPKConstraintName |
Returns the name of the primary key constraint.
(Inherited from AbstractTableManager.) |
| GetPrimaryKeyColumns |
Returns list of column names which represent primary keys of the specified database table.
Returns empty list if primary keys are not found.
(Inherited from AbstractTableManager.) |
| GetTablePKName |
Returns name of the primary key. If more columns in PK, names are separated by semicolon ";".
(Inherited from AbstractTableManager.) |
| GetTables |
Gets the tables in the current database
(Inherited from AbstractTableManager.) |
| GetType | Gets the (Inherited from Type of the current instance.Object.) |
| GetValueString |
Returns the value string using the database culture. Does not include apostrophes for types that need them
(Inherited from AbstractTableManager.) |
| GetXmlSchema |
Returns XML schema for specified table.
(Inherited from AbstractTableManager.) |
| ChangeDBObjectOwner |
Changes database object owner.
(Inherited from AbstractTableManager.) |
| MemberwiseClone | Creates a shallow copy of the current (Inherited from Object.Object.) |
| RecreatePKConstraint |
Drops the current primary key constraint and creates new from given columns.
(Inherited from AbstractTableManager.) |
| RefreshView |
Refreshes specified view in database.
(Inherited from AbstractTableManager.) |
| RenameColumn |
Changes name of the column.
(Inherited from AbstractTableManager.) |
| RenameTable |
Changes name of the table with original name according to the new name.
(Inherited from AbstractTableManager.) |
| StoredProcedureExists |
Determines whether specified stored procedure exists or not.
(Inherited from AbstractTableManager.) |
| TableExists |
Determines whether specified DB table exists or not.
(Inherited from AbstractTableManager.) |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| ViewExists(String) |
Determines whether specified DB view exists or not.
(Inherited from AbstractTableManager.) |
| ViewExists(String, String ) |
Determines whether specified DB view exists or not.
(Inherited from AbstractTableManager.) |
Extension Methods
| Name | Description | |
|---|---|---|
 | GetAPIString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| GetString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| ToBoolean |
Returns the boolean representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDateTime |
Returns the DateTime representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDouble |
Returns the double representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToGuid |
Returns the Guid representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToInteger |
Returns the integer representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToString |
Returns the string representation of an object or default value if not.
(Defined by CoreExtensions.) |
Fields
| Name | Description | |
|---|---|---|
 | mDatabaseCulture |
Database culture setting from the web.config.
(Inherited from AbstractTableManager.) |
Properties
| Name | Description | |
|---|---|---|
 | ConnectionString |
Connection string to use for table management
(Inherited from AbstractTableManager.) |
| DatabaseCulture |
Database culture setting from the web.config.
(Inherited from AbstractTableManager.) |
| DatabaseName |
Database name.
(Inherited from AbstractTableManager.) |
| DatabaseServerName |
Name of database server.
(Inherited from AbstractTableManager.) |
| DatabaseServerVersion |
Version of database server.
(Inherited from AbstractTableManager.) |
| DatabaseSize |
Database size(including log size) in MB.
(Inherited from AbstractTableManager.) |
| DatabaseVersion |
Database version
(Inherited from AbstractTableManager.) |
| DisableDebug |
If true, the debug is disabled in this table manager
(Inherited from AbstractTableManager.) |
See Also