Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# MVC
Hi to all
 
My senior developer has given me a his project to finish. For his data access he uses NHibernate. He said that its okay for me to use any other method of data access that i am quite comfortable with, which is access the database through stored procedures. My question is are object relational mapping tools better than accessing the database through stored procedures. Or are stored procedures a thing of the past. I need advice on the best way to access data in the database produces the best performance results.
 
Thanks in advance
Posted 22-Apr-13 23:25pm
Comments
AlluvialDeposit at 23-Apr-13 5:25am
   
If you're only concern is performance (and that's really important), then go for stored procedures. If you want to write maintainable code, use object relational mapping tools. It's much easier to maintain code and do business logic in your application rather than doing this in your database. And the performance isn't that much better by using stored procedures.

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

  Print Answers RSS
0 OriginalGriff 341
1 Marcin Kozub 225
2 Sergey Alexandrovich Kryukov 220
3 Praneet Nadkar 197
4 Shweta N Mishra 161
0 OriginalGriff 8,149
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 23 Apr 2013
Copyright © CodeProject, 1999-2014
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