ORM Smackdown!

In case you missed it, there was a very amusing DotNetRocks episode this week, billed as an 'ORM Smackdown' (listen here) between Ted Neward and Orein 'Ayende Rahein' Eini

Here's my summary of some of the points of contention [note that this is in my words, not theirs and i expect i've completely missed the point on most of these ;-) ]...

Ted SaysOren Says
ORMs require extra round tripsYou can always put the ORM layer in the same physical tier as the DB
Adding an ORM increases the Impedence Mismatch...but it's worth it cause it provides loose coupling.
Sprocs can act as loose coupling anyway!No, not really!
Yes really!!No, not really!!
Yes really!!!No, not really!!!
Yes really!!!!No, not really!!!!
Yes really!!!!!No, not really!!!!!
RDBMS neutrality is a premature optimisationNo, not really.
Sql Tuning is platform specificAn ORM can have platform specifics tuning
Maybe, but the ORM would be a lot of hard workNo it's easy! Try it!
I have and i hate it!I have and I like it!
When the ORM changes the schema, the DBA is gonna have a heart attackDB Schemaing Versioning is fundamentally hard: it's not ORM's fault
But ORMs make it worseNo no, they make it better.
ORMs put inheritance info into the DB schema. I hate that!I don't really mind...
The db schema is the master!The object model is the master!
An object-database, between the App and the real database might be the way to go!How about an intermediate ORM controlled database, in between the App and the real database
Object-databases -- they're not ready for 'enterprise' yet but when they're ready, they'll be greatMaybe Object Databases are the future.

Me, I don't get the whole object database thing, I just groan and think nah, I'm not going to start using nHibernate, nor am I going to look for object databases.

I'll use Linq, and I'll keep using CodeSmith. I'll keep using Stored Procedures, and I'll keep working hard and looking around. But ORM, not for me just yet.

 

I'm currently writing a book about how to build your first product. If you want to build your first product, please sign up to be notified when the book is available.

(By the way, I read every comment and often respond.)

Your comment, please?

Your Name
Your Url (optional)
Note: I may edit, reuse or delete your comment. Don't be mean.