Rapid Agile Development for Prototyping and Rapid Application Development

Navigation: <Root level>

Placeholders

 

 

 

 

Main Menu > Maintenance > Placeholders

 

Placeholders will be substituted with their appropriate value when:

1.A File Manifest is Concatenated with "Apply Placeholders on Concatenate"  checked in the File Manifest dialog.

2.A File Manifest is Executed with "Apply Placeholders on Execute SQL"  checked in the File Manifest dialog.

 

 

 

Placeholders can be Exported to and Imported From CSV files using the "Export to CSV" and "Import Placeholders" context menu items.

 

 

This dialog is displayed when “New” or “Modify” are clicked.

 

 

User Defined Placeholders can be added. Copy the syntax using the  context menu which will allow the syntax (<#_UDFP_#> in the example above) to be pasted into the required file when editing.

 

 

Default System Placeholders

 

Name

Type

Usage

Syntax

Author

Common

System

<#_AUTHOR_#>

Class Member Assignment

Code

System

<#_CLASS_MEMBER_ASSIGNMENT_#>

Class Member Assignment with Primary Key

Code

System

<#_CLASS_MEMBER_ASSIGNMENT_WITH_PRIMARY_KEY_#>

Class Member Declaration

Code

System

<#_CLASS_MEMBER_DECLARATION_#>

Class Member Declaration with Primary Key

Code

System

<#_CLASS_MEMBER_DECLARATION_WITH_PRIMARY_KEY_#>

Class Name

Code

System

<#_CLASS_NAME_#>

Class Name (Base)

Code

System

<#_BASE_CLASS_NAME_#>

Class Name (BLO)

Code

System

<#_CLASS_NAME_BLO_#>

Class Name (DAO)

Code

System

<#_CLASS_NAME_DAO_#>

Class Name (DO)

Code

System

<#_CLASS_NAME_DO_#>

Class Name (MO)

Code

System

<#_CLASS_NAME_MO_#>

Class Name (TO)

Code

System

<#_CLASS_NAME_TO_#>

Class Name (VO)

Code

System

<#_CLASS_NAME_VO_#>

Class Name (WCF)

Code

System

<#_CLASS_NAME_WCF_#>

Class Name (WS)

Code

System

<#_CLASS_NAME_WS_#>

Company Name

Common

System

<#_COMPANY_NAME_#>

Convert Class Members with Primary Key

Code

System

<#_CONVERT_CLASS_MEMBERS_WITH_PRIMARY_KEY_#>

Convert 'from' Suffix

Code

System

<#_CONVERT_FROM_SUFFIX_#>

Convert 'to' Suffix

Code

System

<#_CONVERT_TO_SUFFIX_#>

Copyright

Common

System

<#_COPYRIGHT_#>

Data Model Connection String

Common

System

<#_DATA_MODEL_CONNECTION_STRING_#>

Data Model Database Name

Common

System

<#_DATA_MODEL_DATABASE_NAME_#>

Data Model Database Path

Common

System

<#_DATA_MODEL_DATABASE_PATH_#>

Database User Name

Common

System

<#_DATABASE_USER_NAME_#>

Date

Common

System

<#_DATE_#>

Delete

Common

System

<#_STORED_PROCEDURE_NAME_DELETE_#>

Delete By Foreign Key

Common

System

<#_STORED_PROCEDURE_NAME_DELETE_BY_FOREIGN_KEY_#>

Field Enumeration Declaration

Code

System

<#_FIELD_ENUMERATION_DECLARATION_#>

Field List

Code

System

<#_FIELD_LIST_#>

Field List with Primary Key

Code

System

<#_FIELD_LIST_WITH_PRIMARY_KEY_#>

Fle Header

Common

System

<#_FILE_HEADER_#>

Foreign Key Declarations

Code

System

<#_FOREIGN_KEY_DECLARATIONS_#>

Foreign Key Parameter Declarations

Code

System

<#_FOREIGN_KEY_PARAMETER_DECLARATIONS_#>

Foreign Key Parameters

Code

System

<#_FOREIGN_KEY_PARAMETERS_#>

Foreign Key Relational Class Members

Code

System

<#_FOREIGN_KEY_RELATIONAL_CLASS_MEMBERS_#>

Foreign Key Relational Class Method Declarations

Code

System

<#_FOREIGN_KEY_RELATIONAL_CLASS_METHOD_DECLARATIONS#>

Foreign Key Relational Class Methods

Code

System

<#_FOREIGN_KEY_RELATIONAL_CLASS_METHODS_#>

Foreign Key Relational Class Properties

Code

System

<#_FOREIGN_KEY_RELATIONAL_CLASS_PROPERTIES_#>

Foreign Key Relational WCF Web Service Class Methods

Code

System

<#_FOREIGN_KEY_RELATIONAL_WCF_WEB_SERVICE_CLASS_METHODS_#>

Foreign Key Relational Web Service Class Methods

Code

System

<#_FOREIGN_KEY_RELATIONAL_WEB_SERVICE_CLASS_METHODS_#>

Foreign Keys

Code

System

<#_FOREIGN_KEYS_#>

Insert

Common

System

<#_STORED_PROCEDURE_NAME_INSERT_#>

Insert Output IDENTITY

Common

System

<#_STORED_PROCEDURE_NAME_INSERT_OUTPUT_IDENTITY_#>

Name

Type

Usage

Syntax

Namespace Name

Code

System

<#_NAMESPACE_NAME_#>

Namespace Name for BLL

Code

System

<#_BLL_NAMESPACE_NAME_#>

Namespace Name for Convert Classes

Code

System

<#_CONVERT_NAMESPACE_NAME_#>

Namespace Name for DAL

Code

System

<#_DAL_NAMESPACE_NAME_#>

Namespace Name for Domain Object Managers (MO)

Code

System

<#_DOM_NAMESPACE_NAME_#>

Namespace Name for Domain Objects (DO)

Code

System

<#_DO_NAMESPACE_NAME_#>

Namespace Name for Enumerations

Code

System

<#_ENUMS_NAMESPACE_NAME_#>

Namespace Name for Field Enums

Code

System

<#_FIELD_ENUMS_NAMESPACE_NAME_#>

Namespace Name for Table Enums

Code

System

<#_TABLE_ENUMS_NAMESPACE_NAME_#>

Namespace Name for Transfer Objects (TO)

Code

System

<#_TO_NAMESPACE_NAME_#>

Namespace Name for Value Objects (VO)

Code

System

<#_VO_NAMESPACE_NAME_#>

Namespace Name for WCF Services  (WCF)

Code

System

<#_WCF_NAMESPACE_NAME_#>

Namespace Name for Web Services (WS)

Code

System

<#_WS_NAMESPACE_NAME_#>

Parameter Declaration List

Code

System

<#_PARAMETER_DECLARATION_LIST_#>

Parameter Declaration List with Primary Key

Code

System

<#_PARAMETER_DECLARATION_LIST_WITH_PRIMARY_KEY_#>

Parameter Declaration List with Primary Key if Not IDENTITY

Code

System

<#_PARAMETER_DECLARATION_LIST_WITH_PRIMARY_KEY_IF_NOT_IDENTITY#>

Parameter List

Code

System

<#_PARAMETER_LIST_#>

Parameter List with Primary Key

Code

System

<#_PARAMETER_LIST_WITH_PRIMARY_KEY_#>

Parameter List with Primary Key if Not IDENTITY

Code

System

<#_PARAMETER_LIST_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

Primary Key Field

Code

System

<#_PRIMARY_KEY_FIELD_#>

Primary Key Field Declaration

Code

System

<#_PRIMARY_KEY_FIELD_DECLARATION_#>

Primary Key Parameter

Code

System

<#_PRIMARY_KEY_PARAMETER_#>

Primary Key Parameter Declaration

Code

System

<#_PRIMARY_KEY_PARAMETER_DECLARATION_#>

Primary Key Property

Code

System

<#_PRIMARY_KEY_PROPERTY_#>

Project Name

Common

System

<#_PROJECT_NAME_#>

Property Declaration

Code

System

<#_PROPERTY_DECLARATION_#>

Property Declaration For Interface With Primary Key

Code

System

<#_PROPERTY_DECLARATION_FOR_INTERFACE_WITH_PRIMARY_KEY_#>

Property Declaration with Primary Key

Code

System

<#_PROPERTY_DECLARATION_WITH_PRIMARY_KEY_#>

Quoted Field List

Code

System

<#_QUOTED_FIELD_LIST_#>

Quoted Field List with Primary Key

Code

System

<#_QUOTED_FIELD_LIST_WITH_PRIMARY_KEY_#>

Quoted Parameter List

Code

System

<#_QUOTED_PARAMETER_LIST_#>

Quoted Parameter List With Primary Key

Code

System

<#_QUOTED_PARAMETER_LIST_WITH_PRIMARY_KEY_#>

Quoted Property List

Code

System

<#_QUOTED_PROPERTY_LIST_#>

Quoted Property List with Primary Key

Code

System

<#_QUOTED_PROPERTY_LIST_WITH_PRIMARY_KEY_#>

Schema Name

Common

System

<#_SCHEMA_NAME_#>

Select

Common

System

<#_STORED_PROCEDURE_NAME_SELECT_#>

Select All

Common

System

<#_STORED_PROCEDURE_NAME_SELECT_ALL_#>

Select All By Foreign Key

Common

System

<#_STORED_PROCEDURE_NAME_SELECT_ALL_BY_FOREIGN_KEY_#>

Select All Except

Common

System

<#_STORED_PROCEDURE_NAME_SELECT_ALL_EXCEPT_#>

Select All Except Order By

Common

System

<#_STORED_PROCEDURE_NAME_SELECT_ALL_EXCEPT_ORDER_BY_#>

Select All Order By

Common

System

<#_STORED_PROCEDURE_NAME_SELECT_ALL_ORDER_BY_#>

Solution Name

Common

System

<#_SOLUTION_NAME_#>

SQL Command Add Parameters

Code

System

<#_SQL_COMMAND_ADD_PARAMETERS_#>

SQL Command Add Parameters Foreign Key Only

Code

System

<#_SQL_COMMAND_ADD_PARAMETERS_FOREIGN_KEY_ONLY_#>

SQL Command Add Parameters Primary Key Only

Code

System

<#_SQL_COMMAND_ADD_PARAMETERS_PRIMARY_KEY_ONLY_#>

SQL Command Add Parameters with Primary Key

Code

System

<#_SQL_COMMAND_ADD_PARAMETERS_WITH_PRIMARY_KEY_#>

SQL Command Add Parameters with Primary Key if Not IDENTITY

Code

System

<#_SQL_COMMAND_ADD_PARAMETERS_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

SQL Data Reader Results

Code

System

<#_SQL_DATA_READER_RESULTS_#>

SQL Data Reader Results with Primary Key

Code

System

<#_SQL_DATA_READER_RESULTS_WITH_PRIMARY_KEY_#>

SQL Database Add In Parameters

Code

System

<#_SQL_DATABASE_ADD_IN_PARAMETERS_#>

SQL Database Add In Parameters Primary Key Only

Code

System

<#_SQL_DATABASE_ADD_IN_PARAMETERS_PRIMARY_KEY_ONLY_#>

SQL Database Add In Parameters with Primary Key

Code

System

<#_SQL_DATABASE_ADD_IN_PARAMETERS_WITH_PRIMARY_KEY_#>

SQL Database Add In Parameters with Primary Key if Not IDENTITY

Code

System

<#_SQL_DATABASE_ADD_IN_PARAMETERS_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

SQL Field Assignment

SQL

System

<#_SQL_FIELD_ASSIGNMENT_#>

SQL Field Assignment with Primary Key

SQL

System

<#_SQL_FIELD_ASSIGNMENT_WITH_PRIMARY_KEY_#>

SQL Field Assignment With Primary Key If Not IDENTITY

SQL

System

<#_SQL_FIELD_ASSIGNMENT_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

SQL Field Declaration List

SQL

System

<#_SQL_FIELD_DECLARATION_LIST_#>

SQL Field Declaration List with Primary Key

SQL

System

<#_SQL_FIELD_DECLARATION_LIST_WITH_PRIMARY_KEY_#>

SQL Field Declaration List with Primary Key if Not IDENTITY

SQL

System

<#_SQL_FIELD_DECLARATION_LIST_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

SQL Field List

SQL

System

<#_SQL_FIELD_LIST_#>

SQL Field List with Primary Key

SQL

System

<#_SQL_FIELD_LIST_WITH_PRIMARY_KEY_#>

SQL Field List with Primary Key if Not IDENTITY

SQL

System

<#_SQL_FIELD_LIST_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

SQL Foreign Key Declarations

SQL

System

<#_SQL_FOREIGN_KEY_DECLARATIONS_#>

SQL Foreign Key Parameter Declarations

SQL

System

<#_SQL_FOREIGN_KEY_PARAMETER_DECLARATIONS_#>

SQL Foreign Key Parameters

SQL

System

<#_SQL_FOREIGN_KEY_PARAMETERS_#>

SQL Foreign Key Relational Stored Procedures

SQL

System

<#_SQL_FOREIGN_KEY_RELATIONAL_STORED_PROCEDURES_#>

SQL Foreign Keys

SQL

System

<#_SQL_FOREIGN_KEYS_#>

SQL Foreign Keys Match

SQL

System

<#_SQL_FOREIGN_KEYS_MATCH_#>

SQL IDENTITY Field OUT

SQL

System

<#_SQL_IDENTITY_FIELD_OUT_#>

SQL IDENTITY Field OUT Declaration

SQL

System

<#_SQL_IDENTITY_FIELD_OUT_DECLARATION_#>

SQL Parameter Declaration List

SQL

System

<#_SQL_PARAMETER_DECLARATION_LIST_#>

SQL Parameter Declaration List IDENTITY As OUTPUT

SQL

System

<#_SQL_PARAMETER_DECLARATION_LIST_IDENTITY_AS_OUTPUT_#>

SQL Parameter Declaration List with Primary Key

SQL

System

<#_SQL_PARAMETER_DECLARATION_LIST_WITH_PRIMARY_KEY_#>

SQL Parameter Declaration List with Primary Key if Not IDENTITY

SQL

System

<#_SQL_PARAMETER_DECLARATION_LIST_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

SQL Parameter List

SQL

System

<#_SQL_PARAMETER_LIST_#>

SQL Parameter List with Primary Key

SQL

System

<#_SQL_PARAMETER_LIST_WITH_PRIMARY_KEY_#>

SQL Parameter List with Primary Key if Not IDENTITY

SQL

System

<#_SQL_PARAMETER_LIST_WITH_PRIMARY_KEY_IF_NOT_IDENTITY_#>

SQL Primary Key

SQL

System

<#_SQL_PRIMARY_KEY_#>

SQL Primary Key Declaration

SQL

System

<#_SQL_PRIMARY_KEY_DECLARATION_#>

SQL Primary Key Match

SQL

System

<#_SQL_PRIMARY_KEY_MATCH_#>

SQL Primary Key Parameter

SQL

System

<#_SQL_PRIMARY_KEY_PARAMETER_#>

SQL Primary Key Parameter Declaration

SQL

System

<#_SQL_PRIMARY_KEY_PARAMETER_DECLARATION_#>

SQL Server Name

Common

System

<#_SQL_SERVER_NAME_#>

SQL Stored Procedure Name

Common

System

<#_STORED_PROCEDURE_NAME_#>

Table and Field Enumeration Declaration

Code

System

<#_TABLE_AND_FIELD_ENUMERATION_DECLARATION_#>

Table Enumeration Declaration

Code

System

<#_TABLE_ENUMERATION_DECLARATION_#>

Table Name

Common

System

<#_TABLE_NAME_#>

Table Name Trimmed

Common

System

<#_TABLE_NAME_TRIMMED_#>

Test Database Connection String

Common

System

<#_TEST_DATABASE_CONNECTION_STRING_#>

Test Database Name

Common

System

<#_TEST_DATABASE_NAME_#>

Test Database Path

Common

System

<#_TEST_DATABASE_PATH_#>

Test Schema Name

Common

System

<#_TEST_SCHEMA_NAME_#>

Update

Common

System

<#_STORED_PROCEDURE_NAME_UPDATE_#>

Version

Common

System

<#_VERSION_#>

Year

Common

System

<#_YEAR_#>

 

 

 

 

 

 

 

www.rapidagiledevelopment.com by Cove Bay Software Limited Copyright © 2015