Comments on dave^2 = -1: Messing around with various ORMs

@anonymous,Probably won't be adding an iBatis.Net ...

2008-01-09T16:21:00.000+11:00

@anonymous,
Probably won't be adding an iBatis.Net version. My limited understanding of iBatis is that you write the SQL queries for each entity and save them into a mapping file, then iBatis uses those queries to get your entities. I'm more interested in ORM tools that write the SQL for me :)

Any chance you will also try out iBatis.Net?

2008-01-09T16:11:00.000+11:00

Any chance you will also try out iBatis.Net?

One really important advantage of using LINQ to SQ...

2008-01-08T20:13:00.000+11:00

One really important advantage of using LINQ to SQL is that by learning the LINQ syntax you’re learning a methodology that can be applied across an ever increasing collection of data repositories. LINQ syntax (such as lambda expressions) can be used to query SharePoint, Amazon and before too long, Oracle.

LINQ is far more than just an object persistence technology. To me, this is one of the most important distinctions in terms of which ORM to invest time in learning.

quick turn around on that, and a nice write up. I ...

2008-01-08T17:33:00.000+11:00

quick turn around on that, and a nice write up. I tend to favor castle activerecord or subsonic depending on the need. that's because nhibernate is a little tricky to get used to.

I haven't used entityframework, and only seen the demos of Linq2Sql. I have this reservation about linq2sql because of the potentially really bad things junior coders could do with it.

@josh,I've had a look at Castle ActiveRecord as su...

2008-01-08T16:50:00.000+11:00

@josh,
I've had a look at Castle ActiveRecord as suggested, and added an ActiveRecord version of the sample scenario. If you've got experience with ActiveRecord I'd be grateful if you can point out all the mistakes I've made (particularly the implementation of the many-to-many query). :-)

@josh,Thanks for the comment. I've been meaning to...

2008-01-08T09:00:00.000+11:00

@josh,
Thanks for the comment. I've been meaning to check out ActiveRecord (and Monorail) forever. I'll try have a look and add it to the series.

@h32,
We just have a difference in terminology I think. When I write "LINQ" I mean the language extensions that can query anything.

When I write "LINQ to SQL" I'm referring to the LINQ provider for SQL, as well as the sqlmetal tool and related designer in VS2008, which I believe is all SQL Server specific. You're quite right though, you can get LINQ providers for a number of data sources.

"LinqToSql only supports SQL Server "Well this isn...

2008-01-08T02:55:00.000+11:00

"LinqToSql only supports SQL Server "
Well this isn't quite true. You can query anything with it. E.g. if you want to use MySQL try DBLinq2007 on google code.

You should look at Caslt Project's ActiveRecord. I...

2008-01-08T02:13:00.000+11:00

You should look at Caslt Project's ActiveRecord. It's easy to get going like SubSonic, and is powered by nhibernate. Almost the best of both worlds.

Can I cop out and say Mu? :-) The answer is "it de...

2008-01-07T16:17:00.000+11:00

Can I cop out and say Mu? :-) The answer is "it depends".

Subsonic is great for quickly getting an ActiveRecord-based DAL up-and-running from a database model.

NHibernate is more complicated, but allows you to use persistence-ignorant entities and supports advanced queries. It also works well when you want to develop a domain model independent of the database model (say, using TDD).

LinqToSql only supports SQL Server (which rules it out for my workplace), and generates entities that are tied to your existing data model. It is also very easy to use.

Entity Framework is about more than ORM -- it is about providing unified access to entities in a number of data sources.

So in short, the one that works the best is the one that best fits your current requirements. :-)

So in your opinion which one works best?

2008-01-07T15:38:00.000+11:00

So in your opinion which one works best?