Click or drag to resize

MetaTable Class

A MetaTable defines a table in a database and contains a list of MetaColumns.
Inheritance Hierarchy

Namespace:  Seal.Model
Assembly:  SealLibrary (in SealLibrary.dll) Version: 6.1.0.0 (6.1.0.0)
Syntax
public class MetaTable : RootComponent, ReportExecutionLog

The MetaTable type exposes the following members.

Constructors
  NameDescription
Public methodMetaTable
Initializes 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 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 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 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 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 propertyParameterValues
The parameter values for edition.
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 '@'.
Protected propertyProperties
List of properties of the object
(Inherited from RootEditor.)
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 methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Protected methodFinalize
Allows 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 methodGetExecSQLName
Returns the SQL with the name and the CTE (Common Table Expression)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetLastDisplayOrder
Returns the last order to display the columns
Public methodGetNumericValue
Returns a paramter ineteger value
Protected methodGetProperty
Get a property descriptor from a property name
(Inherited from RootEditor.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodGetValue
Returns the parameter value
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 methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodRefresh
Refresh the dynamic columns
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 methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodUpdateEditor
Update editor attributes
(Inherited from RootEditor.)
Protected methodUpdateEditorAttributes (Overrides RootEditorUpdateEditorAttributes.)
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 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
Top
See Also