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:
- Description of process of generation of code
- Brackets programmer
- The location of assemblies after code generation
- Header (
Caption
) for classes is generated only if it differs from the class name. - When the generation is taken into account the specified path for 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.
Manager inheritances
This item contains information about the inheritance: the indication of the ancestor, the heir(s), the number of references.
Manager views
This section contains information about all the views, existing models specify the class to which belongs the view name and view properties.
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.