to yesteryear's standards such as nHibernate, good old custom ORM, or something like LLBGenPro?
Also, having run the benchmarks, what are your suggestions?
+1
A:
We had a horrible experience with ADO.NET Entities performance using LINQ: the inheritance slows down things immensely. A small database (say, 100 records or so) with 20 classes of which most were inherited, a query could easily take 10s.
So make the inheritance tree as shallow as possibly when using ADO.NET Entities + LINQ.
Rutger Nijlunsing
2009-06-14 10:37:43
+5
A:
Here is exactly what you are looking for, see ORM benchmarks on ormBattle.net
Alex Kofman
2009-08-13 13:40:43
Do you mind putting linq2sql in your tests there ?
sirrocco
2009-08-18 03:39:26
Probably not, we are not sure yet, but: 1) it's not full-featured ORM; 2) L2S is obsolete now, i.e. Microsoft don't plan it's further development. Surely one can download our test suite and implement those tests for any ORM/DAL.
Alex Kofman
2009-08-18 06:41:13
The problem is that the “bench marks” on ORMBattle are not very “real life” and were created by one ORM vender to show his ORM in good light.
Ian Ringrose
2009-09-24 12:54:06
LINQ to SQL benchmark is already there, but it isn't officially published yet. See http://code.google.com/p/ormbattle/source/browse/trunk/Output.txt
Alex Yakunin
2009-10-28 09:09:41
"to show his ORM in good light" - that's wrong. See the above link. 2 months have passed, and the leaders on each test differ quite significantly.
Alex Yakunin
2009-10-28 09:12:00