Complex database operations are modeled as 'ns' type operations. To add this type of an operation to an entity:
- Right-click on the entity and select Operation.
- Choose the stereotype of the operation from the list of available stereotypes.
- You will then be presented with the Create 'ns' Operation Wizard where you can name the operation, it's parameters and select the return type. If the parameter, return type you select is an entity, you must also select a Shadow Type.
To add the SQL for the operation, navigate to the Cúram tab of the Properties view, and edit the SQL property string value.