Let us go over the differences of the above conventional model.  Here disadvantages are given in the sense to understand the advantages of the ORM

• The stored procedures or SQL commands need to be written well in advance.

• Does not support multiple databases – The stored procedures written are only for the SQL server.  The same has to be done for other databases as well.

• Writing SQL queries is a laborious task as well as error prone.

• Most developers do not like writing SQL queries as they do not want to get out of Object oriented world.

• Queries involving even the smallest business logic need to be changed in case of change in the business rules.