Quote:I am using Code first model in my asp.net mvc 4 application with DbContext. Currently, I am using simple Add, Update and Delete and Find methods of DbContext class. But I want to use stored procedures to add, update, delete and find the data so that whenever we do some minor changes in the database. I don’t want to recompile and publish the whole application whenever some minor changes occur in the database. Suppose we add some column or rename the column and table name, we also need to do changes in the model structure. Can you tell me the better way to handle it and how to achieve this? Is using stored procedure with Entity framework code first model is a better way? If we are using database first model, the same problem arising that we need update the model from database and recompile and publish it? Please reply ASAP. Thanks.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip