This is an old revision of the document!
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 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.
Discussion
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.