Click here to Skip to main content
11,796,275 members (77,785 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: MVC
i performed CRUD operations using both Entity Frame work and Stored procedures . here i have one doubt.. what is the best way to doing CRUD operations either Entity Model or Stored procedures?
Posted 2-Apr-13 23:05pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

That all depends on what you need to accomplish. For simple CRUD operations, I would suggest letting EF take care of that for you.
If you have to do a bunch of processing on the database based on CRUD operations, then I would use Stored procedures to keep all that functionality on the database.
sai sagar at 4-Apr-13 1:02am
i worked on Huge project. then which process is better. because i heard like this " Entity frame work is better for small applications. because in case of huge applications any changes made db like Stored procedures then total application redeployed."
Marcus Kramer at 4-Apr-13 9:31am
Why would EF be better for small applications. It applies to large or small scale applications in the same way, and there really is no difference between large and small scale applications when it comes to schema changes in a database. Either way, the assemblies brokering between the database and the application need to be updated.

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

  Print Answers RSS
0 Maciej Los 460
1 Abhinav S 368
2 OriginalGriff 340
3 CPallini 269
4 Sergey Alexandrovich Kryukov 252
0 OriginalGriff 2,012
1 Maciej Los 1,615
2 KrunalRohit 1,310
3 CPallini 1,015
4 Richard MacCutchan 828

Advertise | Privacy | Mobile
Web02 | 2.8.151002.1 | Last Updated 3 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100