title: The advantages and disadvantages of using ORM
body: <p>I would like to discuss the advantages and disadvantages of using ORM (such as ADO.NET).</p>
  
  <h2>Advantages:</h2>
  
  <ul>
  <li>Speeds-up Development - eliminates the need for repetitive SQL code.</li>
  <li>Reduces Development Time. </li>
  <li>Reduces Development Costs. </li>
  <li>Overcomes vendor specific SQL differences - the ORM knows how to write vendor specific SQL so you don't have to. </li>
  </ul>
  
  <h2>Disadvantages:</h2>
  
  <ul>
  <li>Loss in developer productivity whilst they learn to program with ORM. </li>
  <li>Developers lose understanding of what the code is actually doing - the developer is more in control using SQL. </li>
  <li>ORM has a tendency to be slow.</li>
  <li>ORM fail to compete against SQL queries for complex queries. </li>
  </ul>
  
  <p>In summary, I believe that the advantages of using an ORM (mainly the reduced time taken to perform repetitive tasks) are far outweighed by the disadvantages of ORM e.g. it's difficulty to get to grips with. </p>
  
  <p>Can people point out where I am going wrong and suggest any further advantages/disadvantages. </p>