of Osobennosti work with the stage configuration and system database

Flexberry ORM Plugin is an expander Flexberry Designer, provides opportunities for the creation and correction of application models, generate code and databases.

Depending on the level of repository object plug-in provides different features.

Opportunities in General are divided into the following groups:

  • C#. In this menu item holds all the operations for working with the application code.
  • SQL. SQL language for database management. This menu item allows you to create and edit database modelled application.
  • Утилиты. In this menu item features utility.

Opportunities for stage

Below are the features provided by the plugin, for the stage.

Code (C#)

The properties of the model

Form property settings of the model allows to describe basic and advanced properties of the model. Description of the form presented in the article setting the model for generation.

Generate

Allows to generate a kind of “backbone” of the future application base code, which subsequently can be modified.

Selecting this menu item will display the form with the offer to generate (objects), business server (BusinessServers). Business servers will be generated only if it is provided by the model. Also you can generate all at the same time.

The features and capabilities of code generation:

Compile

Allows to obtain an equivalent description of the algorithm in machine-oriented language. Without compiling the code will be impossible.

Selecting this item will also be offered several options, similar to the item “Generate”.

Generate and compile

Allows simultaneous generation and compilation of the application code based on the created model.

Open in Visual Studio

When you select this menu item to be generated (or generated and compiled) code will be opened in MS Visual Studio version that is installed on your PC.

SQL

For all available databases, the list of menu options is about the same.

Настройка БД

The settings database in the MS SQL example described in the article database Settings.

Привести database in accordance with моделью

When you select this menu item, the database will be adjusted in accordance with the model (DB will be created (if it wasn’t) and edited in accordance with the changes in the model).

Сгенерировать SQL

Allows you to generate a script to create/update the database.

Microsoft SQL Server

The main query language used — Transact-SQL. Used to work with databases in the size from personal to large databases across the enterprise.

Oracle

Oracle is one of the most common of today’s database management systems. In this database are all the modern requirements such as multi-user access to the system in client-server mode, multi-level protection from unauthorized access, implementation of the principle of independence of data, etc.

Postgre SQL

A free object-relational database management system. PostgreSQL is based on the SQL language and supports many features of the SQL standard:2011.

Microsoft Access

Relational DBMS. Has a wide range of functions, including related queries, communication with external tables and databases.

Utilities

Manager classes

Manager class contains information about all the classes of the created model, and also a indication of type and number of references in the model.

Manager associations

This paragraph contains information about the relationships between classes and specify the type of connection as well as the number of references to relations.

Example

Manager inheritances

This item contains information about the inheritance: the indication of the ancestor, the heir(s), the number of references.

Example

Manager views

This section contains information about all the views, existing models specify the class to which belongs the view name and view properties.

Example

To update the submission

This menu item allows you to detect errors in submissions, and to remove irrelevant properties.

To find the errors in the model

Check models for the presence of unused objects and error metadata.

Export stage

Allows you to export the stage to either a local folder on your PC. This allows you to use the stage in other application models.

To import stage you need to use a menu module at the configuration level.

Save chart to wmf format

Allows you to save charts of the stages in the WMF format.

License information

Contains information about licenses: product name, contact person, time of action, the license file and additional information about the license. Or, if the license is incorrect, will be to divert to the page of acquisition of a license.

Possibilities for configuration

Below are the features provided by the plugin for configuration.

Utilities

Import stage

Allows you to import stage in the specified configuration.

In addition to this, to import stages there is a special import mechanism.

License information

Similarly as for stage.

Opportunities for system

Below are the features provided by the plugin system.

Utilities

To create the views

This menu item invokes the create prototypes.

The basic version of this form operates in a restricted mode. In particular, as the name of the application you can enter an arbitrary name in the base installation it is ignored. The prefix specifies the prefix name the created views (the prefix can be omitted). The result of the form will generate the presentation for all classes data presented at the diagrams system, with the following names:

  • [A_]L (a view with that name is not generated for [datalow](fd_key-concepts.html)).
  • [A_]E.

Charting classes in the database

There is possibility to generate class diagrams on the structure of the database.

License information

Similarly as for stage.