How to retrive and update data through SQL Server Stored Procedure using MVC4 and Entity Framework 4. Any tutorial that for doing the same. Is it best to use stored procedure. Please help and guide me.
in Entity framework environment, I would not advice using stored procedure...
although, if u r working on old system where bulk of logic is already writen instored procedures, then u can use SP with entity framework... as explained in this tutorial
PrevinKumar
Member
2 Points
6 Posts
Retrive and Update values thourgh SQL server Stored Procedure using MVC4 EF4
May 16, 2012 07:08 AM|LINK
Hi,
How to retrive and update data through SQL Server Stored Procedure using MVC4 and Entity Framework 4. Any tutorial that for doing the same. Is it best to use stored procedure. Please help and guide me.
kedarrkulkar...
All-Star
34013 Points
5468 Posts
Re: Retrive and Update values thourgh SQL server Stored Procedure using MVC4 EF4
May 16, 2012 07:15 AM|LINK
in Entity framework environment, I would not advice using stored procedure...
although, if u r working on old system where bulk of logic is already writen instored procedures, then u can use SP with entity framework... as explained in this tutorial
http://www.asp.net/web-forms/tutorials/getting-started-with-ef/the-entity-framework-and-aspnet-getting-started-part-7
but, if u r creating a new app with fresh logic, avoid SP
hope this helps...
KK
Please mark as Answer if post helps in resolving your issue
My Site
ignatandrei
All-Star
134521 Points
21576 Posts
Moderator
MVP
Re: Retrive and Update values thourgh SQL server Stored Procedure using MVC4 EF4
May 16, 2012 07:24 AM|LINK
MVC is database agnostic. Please see http://msprogrammer.serviciipeweb.ro/2010/03/29/asp-net-mvc-orm-and-viewmodels/
IF you ask only for EF with SP, then ask in the data access forums.
If you have some MVC specific, please detail.