Cannot add Stored Procedure to Model(Code)
Posted: Fri 27 Apr 2012 10:10
Hi,
We have been developing web app using MVC3 architecture and backend as Oracle. We use DevArt tool to generate entity data model in .Net Code.
Once the procedure is created in database, we had to add that procedure in model to use it over code.
After the procedure I created, I cannot get it added to the Entity Model. The procedure is listed in the Model Explorer but none of the code and classes required to call the procedure are automatically created.
I don’t know if this is due to the high number of procedures in our model or if there is some other problem.
But if I expand the nodes from Model explorer to check for complex types I could see the corresponding result class is mapped to the procedure. But I cannot see in solution explorer under xxx.EDML root.
Please get me some usefult tips on this to get resolved.
Thanks in advance
Regards
Maharajan
We have been developing web app using MVC3 architecture and backend as Oracle. We use DevArt tool to generate entity data model in .Net Code.
Once the procedure is created in database, we had to add that procedure in model to use it over code.
After the procedure I created, I cannot get it added to the Entity Model. The procedure is listed in the Model Explorer but none of the code and classes required to call the procedure are automatically created.
I don’t know if this is due to the high number of procedures in our model or if there is some other problem.
But if I expand the nodes from Model explorer to check for complex types I could see the corresponding result class is mapped to the procedure. But I cannot see in solution explorer under xxx.EDML root.
Please get me some usefult tips on this to get resolved.
Thanks in advance
Regards
Maharajan