Generate code for Stored Procedures MVC 5, EF 6, and “Code First from Database

Question

I am using MVC 5, EF 6, and “Code First from  existing Database. For some reasons I can not see Store procedures. I have assign permissions to the stored Procedures but can only  see "Tables and Views" not Stored Procedures. Is this issue Fixed in Visual 2017 or what is the work around. I have a lots of stored procedures and need a way to generate codes. Any help will be appreciated.

---

Ebenezer

Answer 1

Hi denkyira,

According to your description, and I create a simple asp.net MVC application with entity framework, visual studio enterprise 2017, it works fine.

Could you please provide a bit more information about the issue, such as related pictures, how can I reproduce the issue on my side.

In addition, about how to map a stored procedure in EF database first, please refer to:

https://stackoverflow.com/questions/43821023/stored-procedure-in-entity-framework-database-first-approach

Best regards,

Zhanglong Wu

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Hi Wu

You are using the Designer. That Ok. I managed to fine a blog that talks about using the Designer to get the code and copy it to my solution. That is what I am doing now

https://visualstudiomagazine.com/articles/2014/04/01/calling-stored-procedures-from-entity-framework.aspx

Thanks thou

---

Ebenezer