Best arguments for/against introducing ORM technology into a companies dev process

Posted by james on Programmers See other posts from Programmers or by james
Published on 2011-01-31T09:13:28Z Indexed on 2011/01/31 15:33 UTC
Read the original article Hit count: 310

Filed under:

development-process

|

orm

I have started using ORM technology in the last few years. My first exposure was NHibernate. I then moved onto Linq 2 Sql, and Entity Framework.

The issue I have however is, there are some organisations where I have found strong opposition to introducing ORM tools.

They usually have a number of reasons:

they have a lot of built up SQL skills in the team, and are worried about the underlying SQL that ORM's generate.
they have DBA's who like to be able to see the SQL an app uses in order that can review it for best practice.
they are worried about performance (some people have "heard" the ORM's aren't as performant but have no real proof themselves - there may well be some truth in this! :).

So, I'm looking for the best or most convincing arguments that you have put forward FOR the use of ORM tools.

Equally, I would be interested in the against arguments too.

Note: this is NOT a discussion over which ORM I should use.

© Programmers or respective owner

Related posts about development-process

JAMES Mailet development process

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a project that involves writing mailets for Apache James. As far as I can tell, the only way to test a change in my code (on Windows) is through the following steps: Compile the mailet code Build a jar file containing the mailet Copy the jar file into the apps/james/SAR-INF/lib directory Start… >>> More
Do PHP Framworks Speed Up the Development Process?

as seen on Stack Overflow - Search for 'Stack Overflow'
I recently started working for a web firm as a freelancer taking my hobby of coding in PHP to a career level, and since then I have been overwhelmed by the amount of work that needs to be done within short time frames. The problem isn't being able to do what is asked, but being able to do it all… >>> More
Development process for an embedded project with significant hardware changes

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a good idea about Agile development process but it seems it does not fit well with a embedded project with significant hardware changes. I will describe below what we are currently doing (Ad-hoc way, no defined process yet). The changes are divided into three categories and different processes… >>> More
Setting up an efficient and effective development process

as seen on Stack Overflow - Search for 'Stack Overflow'
I am in the midst of setting up the development environment (PHP/MySQL) for my start-up. We use three sets of servers: LIVE - the servers which provide the actual application TEST - providing a testing version before it is actually released DEV - the development servers The development servers run… >>> More
Organising asp.net website development process

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a standard practice to organize the process of developing a simple website. there is no use implementing MVC as there is no data base involved. It will be very useful in organizing the project and separating the aspx files and master page content(this can be very useful in implementing… >>> More

Related posts about orm

Optimizations employed by ORM's

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm teaching JEE, especially JPA, Spring and Spring MVC. As I have not so much experience in large projects, it is difficult to know what to present to students about optimisation of ORM. At the present time, I present some classic optimisation tricks: prepared statements (most of ORM implicitely… >>> More
Which ORM to use with SQL Azure?

as seen on Stack Overflow - Search for 'Stack Overflow'
Just wondering what everyones thoughts on what ORM to use for SQL Azure? I'm fairly comfortable using LINQ-to-SQL and I believe it is possible to get it working with SQL Azure. However, from my understanding (correct me if I'm wrong), no further improvements will be made to Linq-to-SQL in future… >>> More
PHP Doctrine ORM NestedSet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, although I read through the manual here: http://www.doctrine-project.org/documentation/manual/1_2/hu/hierarchical-data I couldn't find a way to move a node from a Leaf to become a Root node. Any clues? The question is trivial for inserting a new node...but what about updating a node? >>> More
PHP PSR-0 + several namespaces in one file and autoload

as seen on Programmers - Search for 'Programmers'
I've been thinking for a while about defining several namespaces in one php file and so, having several classes inside this file. Suppose, I want to implement something like Doctrine\ORM\Query\Expr: Expr.php Expr |-- Andx.php |-- Base.php |-- Comparison.php |-- Composite.php |-- From.php |-- Func… >>> More
FOSUserBundle override mapping to remove need for username

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to remove the need for a username in the FOSUserBundle. My users will login using an email address only and I've added real name fields as part of the user entity. I realised that I needed to redo the entire mapping as described here. I think I've done it correctly but when I try to submit… >>> More