Object Relational Modeling (ORM) Examples

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » Object Relational Modeling (ORM) Examples

Object Relational Modeling (ORM) Examples

Rate Topic

Display Mode

Topic Options

Author

Message

Grant Fritchey

Posted Wednesday, April 09, 2008 6:54 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375, Visits: 25,159

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

sql_lock

Posted Tuesday, June 01, 2010 3:31 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 4:25 PM
Points: 1,289, Visits: 1,536

Grant

Did you get any response on this one?

Thanks

JL

Post #930590

Grant Fritchey

Posted Tuesday, June 01, 2010 6:22 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375, Visits: 25,159

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

meichner

Posted Thursday, June 03, 2010 2:21 PM

SSC 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

CGSJohnson

Posted Wednesday, November 21, 2012 9:30 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:31 AM
Points: 1,384, Visits: 1,085

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

charlesmartinez276

Posted Saturday, December 08, 2012 10:17 AM

Forum 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. Cool

Daytona Beach

Post #1394341

Grant Fritchey

Posted Sunday, December 09, 2012 4:38 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375, Visits: 25,159

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

CGSJohnson

Posted Sunday, December 09, 2012 7:32 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:31 AM
Points: 1,384, Visits: 1,085

OK...thanks, Grant.

Post #1394396

« Prev Topic | Next Topic »

Permissions