Introducing Object Relational Mapper
page 3 of 10
by Uday Denduluri
Feedback
Average Rating: 
Views (Total / Last 10 Days): 40998/ 111

Disadvantages of the Conventional Model

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.


View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-12-09 12:14:51 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search