Click here to Skip to main content
11,490,282 members (34,021 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 3-Apr-13 0:05am
sai sagar1.9K

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 Sergey Alexandrovich Kryukov 520
1 Andy Lanng 233
2 Sascha Lefèvre 210
3 OriginalGriff 188
4 Maciej Los 160
0 Sergey Alexandrovich Kryukov 9,713
1 OriginalGriff 8,475
2 Sascha Lefèvre 3,544
3 Maciej Los 3,106
4 Richard Deeming 2,370

Advertise | Privacy | Mobile
Web03 | 2.8.150520.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