To expose a database table to your app you, need to actively mark that table as exposed. You may also configure which actions should be available for this table.

Each table may be configured with the following permissions:

Per default ,all permissions are turned off for all tables, and you will need to enable them as required.

To configure the permission for a table follow these steps:

1. Make sure that you are inside Aquro App Studio
2. Expand the Backend Services folder in the treeview menu to the left
3. Expand the Database Connections folder
4. Click on the database connection that you want to configure
5. Click on the TABLES tab
6. Configure the different permissions for each table by clicking on the switch button; a green switch means that that action is allowed for that table

Example:

In the above table configuration example View and Insert are allowed for the Demo table and only the Remove action is allowed for the Persons table.

Data mapping

Each table may also be given a data mapping configuration that makes it easier to work with the data inside your app. By mapping the data from the database table to a data model in your app you won't need to care about the names of columns in your database you can continue to work with your regular data models.

To configure the mapping of a database table simply click on the pen icon on a table. This will load the data mapping window.

To map the data from the database into a data model inside your app first select the data model in the list of models to the right and then map the fields from the database with the fields in your model by dragging the field from the left list to the fields in the right list and then click CLOSE when you are done.

By mapping the data from the database to the data in your app you can more easily use Visual Coding to both read and write data directly to your app's database.