The AbstractTableManager type exposes the following members.
Back to Top
Back to Top
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | AbstractTableManager |
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.
|
| 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. Returns the schema of the dropped view
|
| EnsureDefaultValue |
Add apostrophes around the column default value string according to column type.
|
|  Equals | (Inherited from Object.) |
| ExecuteQuery |
Executes query and returns the results in a DataSet.
|
| ExecuteScalar |
Executes query and returns the results in a DataSet.
|
| 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.
|
| GetColumnIndexes |
Returns the DataSet of column indexes.
|
| GetColumnInformation |
Returns DataSet with specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue
|
| GetConnection |
Gets the connection for the table management
|
 | GetConstraintName |
Returns constraint's name truncated to 128 chars (128 chars is limit of database column name).
|
| GetDatabaseInfo |
Gets size related information about the database.
|
| GetDatabaseSize |
Gets database size (including log size) or N/A string if the size cannot be retrieved
|
| GetDatabaseVersion |
Gets the database version
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetList |
Returns list of views or stored procedures.
|
| GetPKConstraintName |
Returns the name of the primary key 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 current database
|
| 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
|
| GetXmlSchema |
Returns XML schema for specified table.
|
| ChangeDBObjectOwner |
Changes database object owner.
|
| 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.
|
| RefreshView |
Refreshes specified view in database.
|
| RenameColumn |
Changes name of the column.
|
| 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.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| ViewExists(String) |
Determines whether specified DB view exists or not.
|
| ViewExists(String, String ) |
Determines whether specified DB view exists or not.
|
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.
|
Properties
| Name | Description | |
|---|---|---|
 | ConnectionString |
Connection string to use for table management
|
| DatabaseCulture |
Database culture setting from the web.config.
|
| DatabaseName |
Database name.
|
| DatabaseServerName |
Name of database server.
|
| DatabaseServerVersion |
Version of database server.
|
| DatabaseSize |
Database size(including log size) in MB.
|
| DatabaseVersion |
Database version
|
| DisableDebug |
If true, the debug is disabled in this table manager
|
See Also