Back to
Latest changes:

This is an old revision of the document!

Data Model Editor - Tables and links page

Use this page to describe tables taking part in the data model.
The page consists of 2 main parts: list of tables in the left side and properties of selected table at the right (the second panel is empty when no table is selected).
The table properties panel is also divided on 2 panels: the properties themselves on the top and the list of table links at the bottom.

To select the table or link just click on it. Properties of the selected table will be shown in the right panel.
To add or delete tables use the corresponding menu items from “Tables” menu.

Table properties

Table alias is an alias for the table in generated SQL statements (optional but needed if you link the table more than once on different conditions)
NOTE: any particular database table can be added to the data model several times with different aliases. It is necessary to eliminate the ambiguities when some two tables have several link paths from one to another. For more information see: Working with aliases.

Table hint(s) is intended to specify locking method used in MS SQL Server syntax (like NOLOCK, ROWLOCK or READCOMMITED). Please note: this options might not be applied to other database servers (like MySQL).

Quote table name check box means if the table name should be put in double quotes in SQL statements - it is useful for table names including spaces and national characters.

To add a new link for selected table just click on Add button near the list of links. Specify link properties and conditions using Edit link dialog and press OK. New link will apear in the list.
To edit existing link - just select in the list and click on Edit button. Press OK when finish editing.
To remove some link - selected it and press Delete button.


, 2015/05/28 13:27
What about the "Extra condition" property? How can I use it and how does it work? Thanks ;)
, 2015/05/28 17:44
Using that property you can setup a condition which will be added into result query anytime where this table is used.
For example if you have Users table you may need to limit the result by user ID.
In this case you can add the following condition: Users.Id = @userId and then replace @userId in result SQL by particular ID of the current user.
Enter your comment: