Click here to Skip to main content
11,705,998 members (59,172 online)
Rate this: bad
good
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
good
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.
  Permalink  
Comments
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 OriginalGriff 208
1 Sergey Alexandrovich Kryukov 142
2 Inimicos 60
3 ppolymorphe 57
4 ProgramFOX 50
0 OriginalGriff 9,037
1 Sergey Alexandrovich Kryukov 8,417
2 CPallini 5,189
3 Maciej Los 4,726
4 Mika Wendelius 3,626


Advertise | Privacy | Mobile
Web04 | 2.8.150819.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