The advantages and disadvantages of using ORM

Posted by JHarley1 on Stack Overflow See other posts from Stack Overflow or by JHarley1
Published on 2011-01-12T10:51:38Z Indexed on 2011/01/12 10:53 UTC
Read the original article Hit count: 390

Good Morning,

I would like to discuss today the advantages and disadvantages of using ORM (such as ADO.NET).

Advantages:

  • Speeds-up Development - eliminates the need for repetitive SQL code.
  • Reduces Development Time.
  • Reduces Development Costs.
  • Overcomes vendor specific SQL differences - the ORM knows how to write vendor specific SQL so you don't have to.

Disadvantages:

  • Loss in developer productivity whilst they learn to program with ORM.
  • Developers loose understanding of what the code is actually doing - the developer is more in control using SQL.
  • ORM has a tendency to be slow.
  • ORM fail to compete against SQL queries for complex queries.

In summary, I believe that the disadvantages of using an ORM (mainly the reduced time taken to perform repetitive tasks) is far outweighed by the disadvantages of ORM e.g. its difficulty to get to grips with.

Can people point out were I am going wrong and suggest any further advantages/disadvantages.

Many Thanks, J

© Stack Overflow or respective owner

Related posts about orm

Related posts about programming-languages