Which .NET Object Relational Mapper is fastest?

Question

I want to use an Object Relational Mapper (ORM) tool for my ASP.NET application. I have three options: NHibernate, LINQ to SQL, and Subsonic. Which one is fastest?

Answer 1

How about these questions? Subsonic Vs NHibernate and What are the differences and pros and cons of these ORM tools/technologies?.

Answer 2

There is no way to really answer this question without specific use cases. nHibernate has lots of functionality that allows you to optimize its performance (Fetching strategies, lazy loading, future queries etc).

Answer 3

You should investigate/try each one and pick the tool that best fits your needs (i.e. featureset, ease-of-use, etc.).

Unfortunately, this is about the best answer you can get without providing a concrete example of what you trying to accomplish.

Answer 4

Any time you add a layer you loose performance, but with ORM you gain time to market which in alot of cases is more important then anything, I personaly like LINQ to SQL or CodeSmith LINQ to SQL has a lot of customizations for performance and also allows the use o SP, the one key thing of my decision is integration with VS, if it does not integrate I prefer not to use it. One very important thing to keep in mind is performance is a big mith between developers, as long as the users are happy that is not an issue.

Answer 5

I've used NHibernate for a little and I think is a bit complicated. If your doesn't develop anything in Java I try to not use this ORM.

Answer 6

See ORMBattle.NET, but pay attention to description of performance tests.

Spending some time on studying FAQ there is highly recommended as well.

Short answer: among these 3 LINQ to SQL is definite leader on reads, and NHibernate - on writes. IMHO Subsonic isn't best choice from any point (bad LINQ, bad performance).