I'm following this article to create the entityframework model, https://www.asp.net/mvc/overview/getting-started/database-first-development/creating-the-web-application
I see all the tables for selection and even the diagram I created shows up. However, when I expanded the Stored Procedures, I see only system spXXXXXXX procedure for selection. I created 4 procedures, 2 with sp prefix and 2 with usp (the sp was added to see maybe it only looks for that) but none of my own SP shows up for selection. How can I fix this?
If I don't have my SP included in the ADO.NET Entity Data Model then how can I reference and call my SP in the code? Thank you.