To create a role, follow these steps:
- Choose to add a new item to the project.
- In the Add New Item dialog, select Data Model from the left-hand list and Query from the right.
- Enter ConWHSVehicleTruckPolicy in the Name field and click on Add.
- In our new query, drag the ConWHSVehicleTable table to the Data Sources node.
- Add the VehicleType field to the Fields list by right-clicking on the Fields node and choosing New | Field.
- Drag the field onto the Ranges node.
- On the new VehicleType range, change the Value property to Truck.
When deployed, this will be updated for us. We can also use the enum's value as the type is not extensible.
- Save and close the query designer.
- Add a new item to the project.
- In the Add New Item dialog, ...