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 @ 3:30 PM
Points: 14,802, Visits: 27,275
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 2012 Query Performance Tuning
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
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:14 AM
Points: 1,487, Visits: 1,687
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 @ 3:30 PM
Points: 14,802, Visits: 27,275
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 2012 Query Performance Tuning
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
Posted Wednesday, November 21, 2012 9:30 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 1,516, Visits: 1,292
Hi, Grant. Given it has been a while since your last post on this topic, and with the introduction of new releases of E/F, any new opinion(s)?

Thanks...Chris
Post #1387486
Posted Saturday, December 08, 2012 10:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 08, 2012 9:25 PM
Points: 8, Visits: 3
I had to change this function from protected to public in Data Mapper (even though it is documented). Add your modules through a config or helper file.

Daytona Beach
Post #1394341
Posted Sunday, December 09, 2012 4:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:30 PM
Points: 14,802, Visits: 27,275
CGSJohnson (11/21/2012)
Hi, Grant. Given it has been a while since your last post on this topic, and with the introduction of new releases of E/F, any new opinion(s)?

Thanks...Chris


Nope. Sorry. I left that company. I haven't heard anything in six months, but the last I did hear, they still hadn't released it to production. They were facing major performance bottlenecks all over the place. They had to build a second, normalized database, because they were unable to do even the simplest reports from the object-only database. It doesn't sound good.

I'm still not anti-ORM, but, it does seem that it's extremely easy to use an ORM tool in a horribly inappropriate fashion and that the ramifications from that are seriously far-reaching.


----------------------------------------------------
"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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1394394
Posted Sunday, December 09, 2012 7:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 1,516, Visits: 1,292
OK...thanks, Grant.
Post #1394396
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse