Meta |
A MetaTable defines a table in a database and contains a list of MetaColumns.
Inheritance HierarchyNamespace: Seal.Model
Assembly: SealLibrary (in SealLibrary.dll) Version: 8.3.0.0+c4d725cbae26375217e6c77c92a07fffaea6377d
SyntaxC#
public class MetaTable : RootComponent, ReportExecutionLog
The MetaTable type exposes the following members.
ConstructorsProperties| Name | Description | |
|---|---|---|
 | Alias | If not empty, table alias name used in the SQL statement. The table alias is necessary if a SQL Statement is specified. |
| AliasName | Alias name of the table |
| CacheDuration | Duration in seconds to keep the result DataTable in cache after a load. If 0, the table is always reloaded. |
| Columns | List of MetColumn defined for the table |
| DefaultDefinitionInitScript | Default definition init script coming either from the template or from the root table (for a subtable) |
| DefaultDefinitionScript | Default definition script coming either from the template or from the root table (for a subtable) |
| DefaultLoadScript | Default load script coming either from the template or from the root table (for a subtable) |
| DefinitionInitScript | Optional Razor Script executed before the execution of the DefinitionScript |
| DefinitionScript | The Razor Script used to built the DataTable object that defines the table |
| DisplayName | Display name including the type |
| DynamicColumns | If true, columns are generated automatically from the Table Name or the SQL Select Statement by reading the database catalog |
| Error | Last error message |
| FullDisplayName | Display name including the type and the source name |
| FullSQLName | Full SQL name of the table |
| GUID |
The unique identifier
(Inherited from RootComponent) |
| HelperCheckTable | Editor Helper: Check the table definition |
| HelperRefreshColumns | Editor Helper: Create or update dynamic columns for this table |
| IgnorePrePostError | If true, errors occuring during the Pre or Post SQL statements are ignored and the execution continues |
| Information | Last information message |
| IsForSQLModel | True if the table is for a SQL Model |
| IsMongoDb | True if the table is for a Mongo DB |
| IsSQL | True if the source containing the table is a standard SQL source |
| IsSubTable | True if the table is a sub-table of a model |
| KeepColumnNames | "If true, the display names of the columns are kept when generated from the source SQL |
| LINQExpressionName | LINQ expression of the table name |
| LINQResultName | Name of the DataTable LINQ Result: Source name for SQL, table name for No SQL |
| LINQSourceGUID | Source GUID for the LINQ Sub-models |
| LoadScript | The Default Razor Script used to load the data in the table. This can be overwritten in the model. |
| MongoStagesScript | Razor Script executed for Mongo DB table to add stages executed on the server before the load. This script is automatically generated from the model definition. It can be overwritten if the 'Generate Mongo DB stages' parameter of the table is set to false. Use the 'Refresh Sub-Models and Sub-Tables' button in the model to generate and view the script. |
| MustRefresh | If true, the table must be refreshed for dynamic columns |
| Name |
Name of the table in the database. The name can be empty if an SQL Statement is specified.
(Overrides RootComponentName) |
| Parameters | List of Table Parameters |
| PostSQL | SQL Statement executed after the query when the table is involved. The statement may contain Razor script if it starts with '@'. |
| PreSQL | SQL Statement executed before the query when the table is involved. The statement may contain Razor script if it starts with '@'. |
| Source | Current MetaSource |
| Sql | SQL Select Statement executed to define the table. If empty, the table name is used. |
| TableTemplate | |
| TemplateName | The Razor Script used to built the DataTable object that defines the table |
| Type | Type of the table got from database catalog |
| WhereSQL | Additional SQL added in the WHERE clause when the table is involved in a query. The text may contain Razor script if it starts with '@'. |
Methods| Name | Description | |
|---|---|---|
 | AfterSerialization | Operations performed after the serialization |
| BeforeSerialization | Operations performed before the serialization |
| BuildNoSQLTable | For No SQL Source, build the DataTable from the DefinitionScript, if withLoad is true, the table is then loaded with the LoadScript |
| CheckTable | Check the table. If a MetaColumn is specified, only the column is checked. |
 | Create | Creates a basic MetaTable |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetBoolValue | Returns a parameter boolean value with a default if it does not exist |
| GetDoubleValue | Returns a parameter double value |
| GetExecSQLName | Returns the SQL with the name and the CTE (Common Table Expression) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetLastDisplayOrder | Returns the last order to display the columns |
| GetNumericValue | Returns a parameter integer value |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| GetValue | Returns the parameter value |
| HasSameMongoCollection | True if the table has the same mongo DB connection, database and collection |
| Init |
Init the editor objects
(Inherited from RootEditor) |
| InitDefaultValues |
Init the default values
(Inherited from RootEditor) |
| InitEditor |
Init the editor objects and the default values
(Inherited from RootEditor) |
| InitParameters | Init the parameters from the template |
| IsIdentical | Helper to check if the 2 MetaTable have the same definition |
| LogMessage | Logs message in the execution log |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| Refresh | Refresh the dynamic columns |
| ResetDisplayOrder | Reset the Display Order |
| SetReadOnly |
Set all properties to readonly
(Inherited from RootEditor) |
| ShouldSerializeParameters | |
| ShowValues | Return the values from a column in the table |
| SortColumns | Sort the table columns either by alphanumeric order or by position |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| UpdateEditor |
Update editor attributes
(Inherited from RootEditor) |
| UpdateEditorAttributes |
Refresh properties attrivutes
(Inherited from RootEditor) |
Fields| Name | Description | |
|---|---|---|
 | _dctd | (Inherited from RootEditor) |
| _GUID | (Inherited from RootComponent) |
| _name | (Inherited from RootComponent) |
 | IsEditable | True if the table is editable |
| LoadDate | Load date time to handle caching for No SQL tables |
| Log | Current execution log |
| Model | Report Model when the MetaTable comes from a SQL Model or when is a SubTable of a LINQ query |
| MongoStages | Pipeline stages for Mongo queries |
| NoSQLCacheTable | DataTable used for Cache Table (No SQL Source) |
| NoSQLModel | ReportModel set for No SQL Source |
| NoSQLTable | DataTable used for No SQL Source |
| ParameterNameMongoArrayName | |
| ParameterNameMongoCollection | |
| ParameterNameMongoDatabase | |
| ParameterNameMongoRestrictionOperator | |
| ParameterNameMongoSync | |
| WithDataLoad | Set to true if the Load of the table must also include data |
See Also