The following section will show you how you can take advantage of generating against stored procedures and views.
We will start by opening by going back into our Entities.csp Edit Output dialog as shown in the previous step. You can open this dialog by right clicking the Entities.csp template and select selecting Manage Outputs. After the manage outputs dialog comes up, double click on the Entities.cst item.
Once the Entities Edit Output dialog is opened. You , you will need to check the IncludeFunctions and IncludeViews properties as shown below. When we set these two properties to true, the templates will enable stored procedure and view support.
...
Since earlier versions of the templates didn't support views and stored procedures. We , we decided against breaking backwards compatibility with the Entities output, this . This saves you from having to reconfigure all of your outputs when upgrading. But this also prevents you from selecting what business object type a view and stored procedure will be generated as. Since you can't choose a view or stored procedure inside of the Entities.csp Edit Output screen. You , you might be wondering how "How do I configure my business object types then?" The solution is to control this by adding an Extended Property to your stored procedure or view!
| Info |
|---|
| A business object will not be generated from an existing view or stored procedure if the view or stored procedure doesn't contain one of the extended property's below. |
| Info |
|---|
| You can quickly add an Extended Property through Schema Explorer! |
Here is a list of the valid Extended Property names that can be added to a an existing view or stored procedure.
...
After you have added an extended property , all to your view or stored procedure. All you need to do is regenerate and watch your new business objects be added to the project!
...