Introducing Object Relational Mapper
page 3 of 10
by Uday Denduluri
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  |  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