Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Object Relational Modeling (ORM) Examples Expand / Collapse
Author
Message
Posted Wednesday, April 09, 2008 6:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:21 PM
Points: 11,885, Visits: 22,843
I really need some help on this one. One of our development teams is looking into ORM as a way to get code out the door faster. I've been doing a bunch of research on the topic (I'll post the links below) and I've found some interesting discussions over the pluses & minuses of the methdology. There are lots of positive examples of how well it works from all the vendors of various ORM products. I can't find any concrete examples of failed projects or long term maintenance nightmares or anything else like that. Even if ORM is the greatest thing since the flush toilet, there must be failures out there. Does anyone have any links or can provide any examples on failed or problematic ORM implementations?

I'm not trying to prevent the use of ORM, but I want as thorough an understanding of any possible problems as I can. Please help.

Here are a few of the links that I found useful:
http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=78&t=000447
http://groups.google.com/group/ruby-talk-google/browse_thread/thread/938ae1538a84602d
This one is widely quoted
http://blogs.tedneward.com/2006/06/26/The+Vietnam+Of+Computer+Science.aspx
And answered directly
http://www.codeproject.com/KB/architecture/ORM_Vietnam.aspx
http://rapidapplicationdevelopment.blogspot.com/2007/08/create-data-disaster-avoid-unique.html
http://www.devx.com/vb2themax/Article/19894
http://www.eggheadcafe.com/tutorials/aspnet/e957c6de-8400-4748-b42d-027f7a228063/objectrelational-mapping.aspx



----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #482253
Posted Tuesday, June 01, 2010 3:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, February 06, 2012 1:50 AM
Points: 1,171, Visits: 1,376
Grant

Did you get any response on this one?

Thanks

JL
Post #930590
Posted Tuesday, June 01, 2010 6:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:21 PM
Points: 11,885, Visits: 22,843
Not really. I've been posting about it on my blog for the last two years. Our project is... well, we'll see how it turns out. At the moment, I don't have much hope for it in terms of performance or maintainability. It'll work.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #930649
Posted Thursday, June 03, 2010 2:21 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, February 06, 2012 12:43 PM
Points: 215, Visits: 640
I wanted to say thanks for posting those links. They were very intersting.
Post #932413
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse