locked
I don't see my stored procedures using EF Designer? RRS feed

  • Question

  • User-763603659 posted

    I follow this example, https://www.asp.net/mvc/overview/getting-started/database-first-development/creating-the-web-application, using VS2013. All is well for creating the data model except that I do not see my stored procedures that I created in the database shows up for me to check to be part of the model creation.  The database and usp were first created in SQL 2012.  Am I missing any steps that could cause this?  Also, with this example, I didn't have to install EF Designer in my project either but the tables classes were all created just fine.

    Thank you.

    Thursday, June 11, 2015 12:33 PM

All replies

  • User177399542 posted

    Hi Taichung 

    StoredProcedures and Functions are not visible in EF Designer[Diagram]. To view your stored procedure try this:

    Friday, June 12, 2015 2:43 AM
  • User61956409 posted

    Hi Taichung,

    Thanks for your post.

    Firstly, please make sure you have selected stored procedures when you create Entity Data Model.

    Secondly, this article will show you how to add stored procedures into EDM.

    http://www.entityframeworktutorial.net/stored-procedure-in-entity-framework.aspx

    Best Regards,

    Fei Han

    Friday, June 12, 2015 2:52 AM
  • User-763603659 posted

    Hi and thank you both for helping.  I did select and expanded the Stored Procedure when creating the model but all I see is some diagram sp or functions.  All the tables are there and models created for them correctly so I know I'm connecting to the right DB.  I'm including screen shots from SSMS to show that I have 4 sp that I created that are not showing.

    Gees, how does one post a image here?  I try copy and past but it just shows a empty frame.Frown

    screen1

    Friday, June 12, 2015 1:08 PM