Click or drag to resize

MetaTable Class

A MetaTable defines a table in a database and contains a list of MetaColumns.
Inheritance Hierarchy
SystemObject
  Seal.ModelRootEditor
    Seal.ModelRootComponent
      Seal.ModelMetaTable

Namespace: Seal.Model
Assembly: SealLibrary (in SealLibrary.dll) Version: 8.1.0.0+4fe7975a95558d7cdf0d4c425e2c3a22827d67dd
Syntax
C#
public class MetaTable : RootComponent, ReportExecutionLog

The MetaTable type exposes the following members.

Constructors
 NameDescription
Public methodMetaTableInitializes a new instance of the MetaTable class
Top
Properties
 NameDescription
Public propertyAlias If not empty, table alias name used in the SQL statement. The table alias is necessary if a SQL Statement is specified.
Public propertyAliasName Alias name of the table
Public propertyCacheDuration Duration in seconds to keep the result DataTable in cache after a load. If 0, the table is always reloaded.
Public propertyColumns List of MetColumn defined for the table
Public propertyDefaultDefinitionInitScript Default definition init script coming either from the template or from the root table (for a subtable)
Public propertyDefaultDefinitionScript Default definition script coming either from the template or from the root table (for a subtable)
Public propertyDefaultLoadScript Default load script coming either from the template or from the root table (for a subtable)
Public propertyDefinitionInitScript Optional Razor Script executed before the execution of the DefinitionScript
Public propertyDefinitionScript The Razor Script used to built the DataTable object that defines the table
Public propertyDisplayName Display name including the type
Public propertyDynamicColumns If true, columns are generated automatically from the Table Name or the SQL Select Statement by reading the database catalog
Public propertyError Last error message
Public propertyFullDisplayName Display name including the type and the source name
Public propertyFullSQLName Full SQL name of the table
Public propertyGUID The unique identifier
(Inherited from RootComponent)
Public propertyHelperCheckTable Editor Helper: Check the table definition
Public propertyHelperRefreshColumns Editor Helper: Create or update dynamic columns for this table
Public propertyIgnorePrePostError If true, errors occuring during the Pre or Post SQL statements are ignored and the execution continues
Public propertyInformation Last information message
Public propertyIsForSQLModel True if the table is for a SQL Model
Public propertyIsMongoDb True if the table is for a Mongo DB
Public propertyIsSQL True if the source containing the table is a standard SQL source
Public propertyIsSubTable True if the table is a sub-table of a model
Public propertyKeepColumnNames "If true, the display names of the columns are kept when generated from the source SQL
Public propertyLINQExpressionName LINQ expression of the table name
Public propertyLINQResultName Name of the DataTable LINQ Result: Source name for SQL, table name for No SQL
Public propertyLINQSourceGUID Source GUID for the LINQ Sub-models
Public propertyLoadScript The Default Razor Script used to load the data in the table. This can be overwritten in the model.
Public propertyMongoStagesScript 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.
Public propertyMustRefresh If true, the table must be refreshed for dynamic columns
Public propertyName Name of the table in the database. The name can be empty if an SQL Statement is specified.
(Overrides RootComponentName)
Public propertyParameters List of Table Parameters
Public propertyPostSQL SQL Statement executed after the query when the table is involved. The statement may contain Razor script if it starts with '@'.
Public propertyPreSQL SQL Statement executed before the query when the table is involved. The statement may contain Razor script if it starts with '@'.
Public propertySource Current MetaSource
Public propertySql SQL Select Statement executed to define the table. If empty, the table name is used.
Public propertyTableTemplate 
Public propertyTemplateName The Razor Script used to built the DataTable object that defines the table
Public propertyType Type of the table got from database catalog
Public propertyWhereSQL 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 '@'.
Top
Methods
 NameDescription
Public methodAfterSerialization Operations performed after the serialization
Public methodBeforeSerialization Operations performed before the serialization
Public methodBuildNoSQLTable For No SQL Source, build the DataTable from the DefinitionScript, if withLoad is true, the table is then loaded with the LoadScript
Public methodCheckTable Check the table. If a MetaColumn is specified, only the column is checked.
Public methodStatic memberCreate Creates a basic MetaTable
Public methodEqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
Protected methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
Public methodGetBoolValue Returns a parameter boolean value with a default if it does not exist
Public methodGetDoubleValue Returns a parameter double value
Public methodGetExecSQLName Returns the SQL with the name and the CTE (Common Table Expression)
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Public methodGetLastDisplayOrder Returns the last order to display the columns
Public methodGetNumericValue Returns a parameter integer value
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Public methodGetValue Returns the parameter value
Public methodHasSameMongoCollection True if the table has the same mongo DB connection, database and collection
Public methodInit Init the editor objects
(Inherited from RootEditor)
Public methodInitDefaultValues Init the default values
(Inherited from RootEditor)
Public methodInitEditor Init the editor objects and the default values
(Inherited from RootEditor)
Public methodInitParameters Init the parameters from the template
Public methodIsIdentical Helper to check if the 2 MetaTable have the same definition
Public methodLogMessage Logs message in the execution log
Protected methodMemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
Public methodRefresh Refresh the dynamic columns
Public methodResetDisplayOrder Reset the Display Order
Public methodSetReadOnly Set all properties to readonly
(Inherited from RootEditor)
Public methodShouldSerializeParameters 
Public methodShowValues Return the values from a column in the table
Public methodSortColumns Sort the table columns either by alphanumeric order or by position
Public methodToStringReturns a string that represents the current object.
(Inherited from Object)
Public methodUpdateEditor Update editor attributes
(Inherited from RootEditor)
Protected methodUpdateEditorAttributes Refresh properties attrivutes
(Inherited from RootEditor)
Top
Fields
 NameDescription
Protected field_dctd
(Inherited from RootEditor)
Protected field_GUID
(Inherited from RootComponent)
Protected field_name
(Inherited from RootComponent)
Public fieldIsEditable True if the table is editable
Public fieldLoadDate Load date time to handle caching for No SQL tables
Public fieldLog Current execution log
Public fieldModel Report Model when the MetaTable comes from a SQL Model or when is a SubTable of a LINQ query
Public fieldMongoStages Pipeline stages for Mongo queries
Public fieldNoSQLCacheTable DataTable used for Cache Table (No SQL Source)
Public fieldNoSQLModel ReportModel set for No SQL Source
Public fieldNoSQLTable DataTable used for No SQL Source
Public fieldStatic memberParameterNameMongoArrayName 
Public fieldStatic memberParameterNameMongoCollection 
Public fieldStatic memberParameterNameMongoDatabase 
Public fieldStatic memberParameterNameMongoRestrictionOperator 
Public fieldStatic memberParameterNameMongoSync 
Public fieldWithDataLoad Set to true if the Load of the table must also include data
Top
See Also