Database not updating from stored procedures

Rated 4.93/5 based on 926 customer reviews

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.For information about the tutorial series, see the first tutorial in the series In the previous tutorial you implemented a table-per-hierarchy inheritance pattern.This tutorial will show you how to use stored procedures to gain more control over database access.

database not updating from stored procedures-47

database not updating from stored procedures-54

Using stored procedures is a common requirement for database access.

The Contoso University sample web application demonstrates how to create ASP.

NET Web Forms applications using the Entity Framework 4.0 and Visual Studio 2010.

The Entity Framework lets you specify that it should use stored procedures for database access.

For any entity type, you can specify a stored procedure to use for creating, updating, or deleting entities of that type.

Leave a Reply