![]() | |
Tables |
Create tables and columns. Add functions and validators.
This topic contains the following sections.
This section contains the following subsections.
Image | Command | Description |
---|---|---|
![]() | Add Table | Adds an entry to the TABLES table. |
![]() | Delete Table | Deletes selected rows from TABLES table. |
![]() | Toggle Columns | Toggles column filter. |
Name | Description |
---|---|
(blank) | Row index. |
Name | Table name. |
Summary (hidden by default) | Not used. |
Data Member Order (hidden by default) | Specifies poco fields DataMemberAttribute.Order property. |
Omit Table Typing (hidden by default) | Checking suppresses table code generation in the typed dataset class. Untyped access will be granted. |
Omit View (hidden by default) | Checking suppresses the view code generation in the viewmanager class. |
Omit Poco (hidden by default) | Checking suppresses POCO code generation for the table. |
Table Class Name (hidden by default) | Typed table class name. |
Row Class Name (hidden by default) | Typed row class name. |
TableView Class Name (hidden by default) | Typed tableview class name. |
RowView Class Name (hidden by default) | Typed rowview class name. |
Table Property Name (hidden by default) | Typed datasets property name for the table. |
TableView Property Name (hidden by default) | Typed viewmanagers property name for the tableview. |
Name | Description |
---|---|
Name | Table name. |
Omit Table Typing | Checking suppresses table code generation in the typed dataset class. Untyped access will be granted. |
Table Class Name | Typed table class name. |
Table Class Name Auto | When checked "Table Class Name" is inferred from "Table Class Name Format" (see Project/DataSet) and table name. |
Table Property Name | Typed datasets property name for the table. |
Table Property Name Auto | When checked "Table Property Name" is inferred from "Table Property Name Format" (see Project/DataSet) and table name. |
Table Property Modifier | Modifier of typed datasets property name for the table. |
Row Class Name | Typed row class name. |
Row Class Name Auto | When checked "Row Class Name" is inferred from "Row Class Name Format" (see Project/DataSet) and table name. |
Omit View | Checking suppresses the view code generation in the viewmanager class. |
TableView Class Name | Typed tableview class name. |
TableView Class Name Auto | When checked "TableView Class Name" is inferred from "TableView Class Name Format" (see Project/AllViews) and table name. |
TableView Property Name | Typed viewmanagers property name for the tableview. |
TableView Property Name Auto | When checked "TableView Property Name" is inferred from "TableView Property Name Format" (see Project/AllViews) and table name. |
RowView Class Name | Typed rowview class name. |
RowView Class Name Auto | When checked "RowView Class Name" is inferred from "RowView Class Name Format" (see Project/AllViews) and table name. |
Omit Poco (hidden by default) | Checking suppresses POCO code generation for the table. |
This section contains the following subsections.
Image | Command | Description |
---|---|---|
![]() | Add Column | Adds an entry to the COLUMNS table. |
![]() | Find Data Type | Opens the Data Type Browser Dialog. |
![]() | Find Function Type | Opens the Function Type Browser Dialog. |
![]() | Browse Dependencies | Opens the Column Dependencies Browser Dialog. |
![]() | Delete Column | Deletes selected rows from COLUMNS table. |
![]() | Toggle Columns | Toggles column filter. |
Name | Description |
---|---|
(blank) | Row index. |
Name | Column Name. |
Type | Property type name. You may omit namespace when namespace is mentioned in References/NAMESPACES. |
Allow Null (hidden by default) | Determines whether column will accept null value. Unchecking will add a not-null-contraint to the column behaviors. |
Summary (hidden by default) | Not used. |
Default (hidden by default) | Determines a default value. Specifing a default value will add a BcfColumnDefaultValueSourceT to the columns behavior. |
Function (hidden by default) | Functions type name. You may omit namespace when namespace is mentioned in References/NAMESPACES. |
Primary Key (hidden by default) | Determines if column is (a part of) the tables primary key. |
Omit Row Property (hidden by default) | Checking suppresses the property generation in the typed row class. |
Omit RowView Property (hidden by default) | Checking suppresses the property generation in the typed RowView class. |
Omit Poco Field (hidden by default) | Checking suppresses the field generation for the column in the poco class. |
Data Member Order (hidden by default) | Specifies poco fields DataMemberAttribute.Order property. |
Read Only (hidden by default) | Determines if column is read only. |
Parallel (hidden by default) | If not checked function will not be executed parallel. |
Name | Description |
---|---|
Name | Column Name. |
Type | Property type name. You may omit namespace when namespace is mentioned in References/NAMESPACES. |
Type (C#) | Property type c# code. Always read only. |
Default | Determines a default value. Specifing a default value will add a BcfColumnDefaultValueSourceT to the columns behavior. |
Function | Functions type name. You may omit namespace when namespace is mentioned in References/NAMESPACES. |
Function (C#) | Functions type c# code. Always read only. |
Column Property Name | Typed table property name for the column. |
Primary Key | Determines if column is (a part of) the tables primary key. |
Allow Null | Determines whether column will accept null value. Unchecking will add a not-null-contraint to the column behaviors. |
Read Only | Determines if column is read only. |
Omit Poco Field | Checking suppresses the field generation for the column in the poco class. |
Omit Row Property | Checking suppresses the property generation in the typed row class. |
Omit RowView Property | Checking suppresses the property generation in the typed RowView class. |
Allow Compute Parallel | If not checked function will not be executed parallel. |
Column Property Name Auto | When checked "Column Property Name" is inferred from "Column Property Name Format" (see Project/DataSet) and column name. |
This section contains the following subsections.
Image | Command | Description |
---|---|---|
![]() | Add Parameters |
|
![]() | Delete Parameters | Deletes selected rows from PARAMETERS Table. |
![]() | Link Parameter | Opens Access Path Browser Dialog. |
![]() | Generate Code | Generate code and set to clipboard.
|
![]() | Toggle Columns | Toggles column filter. |
Name | Description |
---|---|
(blank) | Row index. |
Name | Parameter name. |
Mandatory | Indicates whether parameter assignment is mandatory (parameter property is decorated with BcfMandatoryAttribute) or not. Always read only. |
Access Path (hidden by default) | Parameter dynamic assignment. Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows distinct rows along the Relation-Steps (prefix "+" means "ToChild"; "-" "ToParent") and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog. |
Value (hidden by default) | Parameter static assignment Constant expression to use as parameter value. |
Summary (hidden by default) | Not used. |
Value Type (hidden by default) | Editor evaluated type depending on "Access Path" and source column type. |
Source Type (hidden by default) | Parameter property type in function class. Always read only. |
Name | Description |
---|---|
Name | Parameter name. |
Parameter Type | Parameter property type in function class. Always read only. |
Value | Parameter static assignment Constant expression to use as parameter value. |
Access Path | Parameter dynamic assignment. Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows distinct rows along the Relation-Steps (prefix "+" means "ToChild"; "-" "ToParent") and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog. |
Source Type | Editor evaluated type depending on "Access Path" and source column type. Always read only. |
Suppress "Potential Circular Reference" Warning | Suppresses "Parameter Column Association with potential circular reference" warning. Warning may occur when using parameter access via self joins. The similar error "Parameter Column Association with unavoidable circular reference" can not be suppressed. |
This section contains the following subsections.
Image | Command | Description |
---|---|---|
![]() | Add Validator | Adds an entry to the VALIDATORS Table and opens the Validator Type Browser Dialog. |
![]() | Add Validator | Opens the Validator Type Browser Dialog. |
![]() | Browse Dependencies | Opens the Column Dependencies Browser Dialog. |
![]() | Delete Validator | Deletes selected rows from VALIDATORS table. |
![]() | Toggle Columns | Toggles column filter. |
Name | Description |
---|---|
(blank) | Row index. |
Validator Type | Validators type name. You may omit namespace when namespace is mentioned in References/NAMESPACES. |
Tagging | A ";"-separated list of parameters to tag. Always read only. |
Summary (hidden by default) | Not used. |
Parallel (hidden by default) | If not checked validator will not be executed parallel. |
Name | Description |
---|---|
Validator | Validators type name. You may omit namespace when namespace is mentioned in References/NAMESPACES. |
Validator (C#) | Validator type c# code. Always read only. |
Tagging | A ";"-separated list of parameters to tag. Always read only. |
Allow Compute Parallel | If not checked validator will not be executed parallel. |
This section contains the following subsections.
Image | Command | Description |
---|---|---|
![]() | Add Parameters |
|
![]() | Delete Parameters | Deletes selected rows from VALIDATOR PARAMETERS Table. |
![]() | Link Parameter | Opens Parameter Access Path Dialog. |
![]() | Generate Code | Generate code and set to clipboard.
|
![]() | Toggle Columns | Toggles column filter. |
Name | Description |
---|---|
(blank) | Row index. |
Name | Parameter name. |
Tag Cell(s) | Determines whether parameter source cells will be tagged with the validator message or not. |
Mandatory | Indicates whether parameter assignment is mandatory (parameter property is decorated with BcfMandatoryAttribute) or not. Always read only. |
Access Path (hidden by default) | Parameter dynamic assignment. Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows distinct rows along the Relation-Steps (prefix "+" means "ToChild"; "-" "ToParent") and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog. |
Value (hidden by default) | Parameter static assignment Constant expression to use as parameter value. |
Summary (hidden by default) | Not used. |
Value Type (hidden by default) | Editor evaluated type depending on "Access Path" and source column type. Always read only. |
Source Type (hidden by default) | Parameter property type in function class. Always read only. |
Name | Description |
---|---|
Name | Parameter name. |
Parameter Type | Parameter property type in validator class. Always read only. |
Value | Parameter static assignment Constant expression to use as parameter value. |
Access Path | Parameter dynamic assignment. Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows distinct rows along the Relation-Steps (prefix "+" means "ToChild"; "-" "ToParent") and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog. |
Source Type | Editor evaluated type depending on "Access Path" and source column type. Always read only. |