Database not updating from stored procedures
Instead, you'll change the way the Entity Framework accesses the database for some of the pages you already created.
Using stored procedures is a common requirement for database access.
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community You should not have to restart the database after adding a new stored procedure, although you will need to refresh your object explorer to see it there.
The next time you add a stored procedure try running the right click execute option from the object explorer and enter your parameters and see if it runs.
You can perform these kinds of tasks in a stored procedure that's called whenever the Entity Framework deletes an entity or updates an entity.
As in the previous tutorial, you'll not create any new pages.
Search for database not updating from stored procedures:
In the data model designer, right-click the design surface and select Model Browser. Store node and then open the Stored Procedures node. Stored procedures to insert, update, and delete data are used by the Entity Framework automatically after you've added them to the data model and mapped them to the appropriate entities.