Is it good to use stored procedure for CRUD operation while using Entity Framework in asp.net web form application?

Question

0.00/5 (No votes)

See more:

Hello there!!!

I am implementing a project where I am using Entity Framework as Data Access Layer.
I have implemented several stored procedures for doing CRUD operations on database in Sql Server; Now I want to use those stored procedures with Entity Framework for doing CRUD operations from my application, So is it good to use Stored Procedures with Entity Framework and Is there any benefit if I am using Stored Procedures with Entity Framework?

Thanks!!!!!

Posted 25-Aug-15 2:25am

Ajay_Patel

Updated 25-Aug-15 2:37am

F-ES Sitecore

v2

Add a Solution

2 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)

F-ES Sitecore · Answer 1 · 2015-08-25T02:39:00

You can use SPs if you want, but you're pretty much defeating the object of using Entity Framework at all. The only real advantage you'll gain is when creating data from the SPs Entity Framework will give you specific classes back with the data already populated rather than you having to read the raw data from an SP like you would with ADO.net.

Awais Malik · Answer 2 · 2015-08-25T02:43:00

Entity framework is ultimately an ORM which facilitates the developer who doesn't know how to write good SQL queries but obviously that facility comes at some cost in terms of performance.

Stored procedures are pre-compiled while EF will generate query every time.
Furthermore the SP based application is more maintainable i.e. suppose you've deployed the project at production server and now you realize that you've to change some computation or data retrieval logic, you can simply connect to live db and change respective stored procedures but in other case (using EF & LINQ entirely) you'll have to make changes in your application code and then re-deploy the code!

So if you are good at writing queries then go ahead with stored procedures. :)

Is it good to use stored procedure for CRUD operation while using Entity Framework in asp.net web form application?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0