Which is the best way for updating records in mvc4

Question

4.00/5 (2 votes)

See more:

, +

Hi
Any one can suggest me which is the best way for updating records either writing update query in stored procedure and call that stored procedure in Entity Framework or directly writing update query in Entity Framework. Which way is faster. I am developing an application in ASP.NET MVC4 ,Entity Framework5 and SQL Server 2008.

Posted 4-Mar-14 20:27pm

Member 10644250

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Answer 1 · 2014-03-04T20:39:00

It depends on the complexity of your SP.But for simple table update you can use inline simple entity framework update query.But if you have very complex multiple table update scenario then use SP with entity framework.It'll give better performance than inline EF query.

If you have any questions,Please ask.

Mehul Thummar · Answer 2 · 2014-03-04T22:33:00

Solution 2

you can use Entity Framework but complex scenario than use Store Procedure.

Posted 4-Mar-14 22:33pm

Mehul Thummar

Suraj Sahoo | Coding Passion · Answer 3 · 2014-04-14T07:52:00

Solution 3

Linq is the best approach using EntityFramework. It is faster and more readable. Stored Procedures are trivial and might create chaos if large number of data are present. Linq can be longer but efficient.
Thank you :)

Posted 14-Apr-14 7:52am

Suraj Sahoo | Coding Passion