MetaTable Class |
Namespace: Seal.Model
The MetaTable type exposes the following members.
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
|
![]() | 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)
|
![]() | 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
|
![]() | 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.
|
![]() | 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
|
![]() | ParameterValues |
The parameter values for edition.
|
![]() | 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 '@'.
|
![]() | Properties |
List of properties of the object
(Inherited from RootEditor.) |
![]() | 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 '@'.
|
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
|
![]() | 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 paramter ineteger value
|
![]() | GetProperty |
Get a property descriptor from a property name
(Inherited from RootEditor.) |
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | GetValue |
Returns the parameter value
|
![]() | 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
|
![]() | 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 | (Overrides RootEditorUpdateEditorAttributes.) |
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
|
![]() | NoSQLCacheTable |
DataTable used for Cache Table (No SQL Source)
|
![]() | NoSQLModel |
ReportModel set for No SQL Source
|
![]() | NoSQLTable |
DataTable used for No SQL Source
|