Click here to Skip to main content
11,922,026 members (59,597 online)
Rate this:
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 3-Apr-13 0:05am

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 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 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 OriginalGriff 568
1 Dave Kreskowiak 285
2 Sergey Alexandrovich Kryukov 173
3 Richard MacCutchan 155
4 ppolymorphe 135
0 OriginalGriff 7,036
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,286
3 George Jonsson 2,840
4 Suvendu Shekhar Giri 2,216

Advertise | Privacy | Mobile
Web01 | 2.8.151120.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