My favorites | Sign in
Project Home Downloads Issues Source
Repository:
Checkout   Browse   Changes   Clones    
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
LINQ tests:
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: DataObjects.Net (DO)
Testing: LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)

LINQ tests scorecard:
BLT EF DO LC L2S NH OA Maximum Unit
LINQ Implementation:
Aggregates 1 0 0 1 0 1 1 5 f/a
All/Any/Contains 1 0 0 0 1 2 3 6 f/a
Complex 6 0 0 2 0 6 4 6 f/a
Element operations 5 4 0 0 2 6 5 9 f/a
Filtering 0 4/2 0 0 2/2 2 0 12 f/a
Grouping 4 1 0 2 1 7/1 2 10 f/a
Join 0 0 0 0 0 1 1 4 f/a
Ordering 0 2/1 0 2 2 4 1/1 8 f/a
Projections 2 1 0 1 1 4 1/1 13 f/a
References 0 0 0 0 0 0 0 4 f/a
Set operations 0 0 0 0 0 6/1 0 9 f/a
Standard functions 0 11/1 2 2/1 3/1 17 9/2 25 f/a
Take/Skip 1 1 0 0 0 2 1 5 f/a
Type casts 0 1 0 1 1 2 4 5 f/a
Total:
Performed 121 121 121 121 121 121 121 121 #
Passed 101 96 119 110 108 61 89 121 #
Failed 20 25 2 11 13 60 32 121 #
Properly 20 21 2 10 10 58 28 121 #
Asserted 0 4 0 1 3 2 4 121 #
Score 83,5 79,3 98,3 90,9 89,3 50,4 73,6 100,0 %

Units:
f/a: total count of failed tests [ / count of tests failed with assertion ],
less is better (0 is ideal);
#: count;
%: percentage (% of passed tests), more is better.


Performance tests (50 items):
Pass 1 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 2 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 3 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 4 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 5 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)

Performance tests (50 items) scorecard:
BLT EF ES DO LC L2S NH OA SS SQL Unit
CRUD Performance:
Fetch 9352 4956 7141 7503 9865 7099 7228 5131 8447 15441 op/s
Single Operation:
Create Instance 6432 3788 5921 5325 6418 4017 3498 2609 3245 8798 op/s
Update Instance 5937 3556 5121 5035 5547 1615 3048 1600 1421 8215 op/s
Remove Instance 5949 3897 5496 5168 5599 1711 3294 2178 1469 8387 op/s
CUD Average 6097 3689 5390 5068 5700 2051 3198 2010 1758 8348 op/s
Multiple Operations:
Create Instance 23529 7236 9896 16687 21409 5740 15936 10834 4115 25588 op/s
Update Instance 21589 7010 9391 17438 18208 2042 12895 10094 3071 27760 op/s
Remove Instance 27386 7968 10273 20108 23031 2179 14169 21159 3148 33719 op/s
CUD Average 23542 7333 9787 17643 20682 2653 14148 12508 3313 28419 op/s
Data Access Performance:
Query:
LINQ Query 5237 538 785 1452 3499 713 1008 2957 224 n/a queries/s
Compiled LINQ Query 7644 4799 2214 6076 6619 6670 n/a 3055 n/a n/a queries/s
Native Query 8552 5870 5935 5673 n/a n/a 4337 4213 6075 11397 queries/s
Paging (LINQ only):
Get Small Page (10 items) 5070 3121 1845 3982 4329 4404 788 1966 210 n/a pages/s
Get Average Page (20 items) 2878 1861 1400 2186 2476 2625 574 1321 188 n/a pages/s
Get Large Page (50 items) n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
Get Huge Page (100 items) n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
Materialization:
LINQ Materialize 60306 14590 17985 54668 49627 39013 27566 34633 10548 n/a objects/s
Native Materialize 99900 66181 73681 69013 n/a n/a 40025 56980 65530 142979 objects/s

Units:
op/s: operations per second, more is better;
queries/s: queries per second, more is better;
pages/s: pages per second, more is better;
objects/s: # of materialized objects per second, more is better.


Performance tests (100 items):
Pass 1 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 2 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 3 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 4 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 5 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)

Performance tests (100 items) scorecard:
BLT EF ES DO LC L2S NH OA SS SQL Unit
CRUD Performance:
Fetch 10349 5157 7449 8069 10515 7633 7705 5474 8737 17657 op/s
Single Operation:
Create Instance 8012 4272 6954 6401 8148 4655 4038 2357 3406 11769 op/s
Update Instance 7582 4126 6337 6323 7227 1770 3186 1687 2084 10827 op/s
Remove Instance 7832 4540 6685 6417 7481 1836 3621 2440 2178 11280 op/s
CUD Average 7804 4281 6639 6364 7526 2249 3549 2074 2419 11194 op/s
Multiple Operations:
Create Instance 29218 7415 10400 18862 25015 5892 18007 12395 3657 30546 op/s
Update Instance 27207 7236 9947 20702 21230 1880 15245 11408 3478 33131 op/s
Remove Instance 36813 8317 11004 22396 28648 1816 16482 29491 3692 44279 op/s
CUD Average 30567 7614 10411 20226 24423 2329 16361 14371 3567 34720 op/s
Data Access Performance:
Query:
LINQ Query 6235 437 814 1542 3849 734 1083 3210 225 n/a queries/s
Compiled LINQ Query 8998 5612 2281 7064 7775 7629 n/a 3379 n/a n/a queries/s
Native Query 11190 6965 6447 7371 n/a n/a 4827 4925 6693 13603 queries/s
Paging (LINQ only):
Get Small Page (10 items) 6664 3532 2001 4980 5267 5674 842 2303 214 n/a pages/s
Get Average Page (20 items) 4664 2611 1735 3325 3691 4160 707 1844 203 n/a pages/s
Get Large Page (50 items) 2512 1417 1261 1709 1927 2319 457 1103 181 n/a pages/s
Get Huge Page (100 items) n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
Materialization:
LINQ Materialize 110168 26615 30648 84495 77966 73980 38069 59977 19138 n/a objects/s
Native Materialize 177683 100644 111969 100613 n/a n/a 52222 93923 86460 254065 objects/s

Units:
op/s: operations per second, more is better;
queries/s: queries per second, more is better;
pages/s: pages per second, more is better;
objects/s: # of materialized objects per second, more is better.


Performance tests (500 items):
Pass 1 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 2 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 3 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 4 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 5 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)

Performance tests (500 items) scorecard:
BLT EF ES DO LC L2S NH OA SS SQL Unit
CRUD Performance:
Fetch 11292 5536 6340 6460 11416 8072 8339 n/a 9456 20074 op/s
Single Operation:
Create Instance 7972 4365 6977 6723 7981 4221 4163 2694 3296 11723 op/s
Update Instance 9945 5009 7980 8397 9590 1512 1729 n/a 3841 15283 op/s
Remove Instance 10336 5639 8531 9124 10306 1762 2275 n/a 3674 16040 op/s
CUD Average 9279 4941 7731 7873 9134 2036 2368 n/a 3467 13805 op/s
Multiple Operations:
Create Instance 22659 5815 9245 15307 19389 5007 15097 n/a 3156 22927 op/s
Update Instance 35424 6371 10835 24964 26210 2024 17275 91427 3672 39771 op/s
Remove Instance 53530 6344 11944 18126 37088 2123 19367 208472 3824 58055 op/s
CUD Average 32843 6165 10545 18618 25543 2574 17011 n/a 3482 34558 op/s
Data Access Performance:
Query:
LINQ Query 7499 511 790 1384 3595 700 1013 3762 219 n/a queries/s
Compiled LINQ Query 11291 6438 2015 8783 9335 9163 n/a 3935 n/a n/a queries/s
Native Query 14348 8397 7718 10057 n/a n/a 5529 5957 7567 17258 queries/s
Paging (LINQ only):
Get Small Page (10 items) 9456 4422 1388 6464 6845 7355 662 2913 207 n/a pages/s
Get Average Page (20 items) 7961 3482 2167 4862 5302 6319 834 2677 193 n/a pages/s
Get Large Page (50 items) 5575 2219 1815 2930 3210 4703 603 2038 202 n/a pages/s
Get Huge Page (100 items) 3566 1359 1508 1738 1932 3308 420 1687 182 n/a pages/s
Materialization:
LINQ Materialize 381242 90643 77637 173955 194893 281373 60055 118331 58731 n/a objects/s
Native Materialize 575904 180805 200916 237439 n/a n/a 74935 154741 119860 823994 objects/s

Units:
op/s: operations per second, more is better;
queries/s: queries per second, more is better;
pages/s: pages per second, more is better;
objects/s: # of materialized objects per second, more is better.


Performance tests (1000 items):
Pass 1 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 2 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 3 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 4 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 5 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)

Performance tests (1000 items) scorecard:
BLT EF ES DO LC L2S NH OA SS SQL Unit
CRUD Performance:
Fetch 11460 4849 7025 7621 11490 7035 7164 n/a 7827 20870 op/s
Single Operation:
Create Instance 8249 3543 7226 6653 8177 3326 4239 2372 2860 11308 op/s
Update Instance 10476 3920 8377 8738 10016 1686 1255 n/a 3777 16135 op/s
Remove Instance 11154 4283 8932 9312 10815 1867 1928 n/a 4146 16905 op/s
CUD Average 9718 3846 8089 7969 9465 2091 1922 n/a 3458 14240 op/s
Multiple Operations:
Create Instance 19115 5232 7796 17143 14089 5881 13439 n/a 3466 40265 op/s
Update Instance 39007 6184 9800 20372 22327 2050 15142 77148 3885 41111 op/s
Remove Instance 59559 7366 10432 24142 27624 2202 19781 233062 3997 62785 op/s
CUD Average 31599 6057 9121 19929 19263 2671 15635 n/a 3649 45881 op/s
Data Access Performance:
Query:
LINQ Query 7651 547 827 1468 2947 735 1062 3199 224 n/a queries/s
Compiled LINQ Query 11889 6521 2164 8965 9412 9457 n/a 3296 n/a n/a queries/s
Native Query 15100 8557 5601 10459 n/a n/a 4315 6048 7604 17791 queries/s
Paging (LINQ only):
Get Small Page (10 items) 10003 4550 1871 6645 6794 7680 860 2981 213 n/a pages/s
Get Average Page (20 items) 8757 3653 1520 5226 5344 7013 700 2716 205 n/a pages/s
Get Large Page (50 items) 6459 2378 1970 3160 3351 5419 626 2168 182 n/a pages/s
Get Huge Page (100 items) 4499 1441 1637 1890 2123 4028 440 1630 187 n/a pages/s
Materialization:
LINQ Materialize 569087 123607 95974 215354 220181 463477 63362 201126 79344 n/a objects/s
Native Materialize 844951 203338 224391 292064 n/a n/a 79037 252563 125939 1220703 objects/s

Units:
op/s: operations per second, more is better;
queries/s: queries per second, more is better;
pages/s: pages per second, more is better;
objects/s: # of materialized objects per second, more is better.


Performance tests (5000 items):
Pass 1 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 2 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 3 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 4 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 5 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)

Performance tests (5000 items) scorecard:
BLT EF ES DO LC L2S NH OA SS SQL Unit
CRUD Performance:
Fetch 10802 5304 8019 8439 11194 7978 7814 n/a 9103 20602 op/s
Single Operation:
Create Instance 8410 4143 8500 7947 7820 2219 4271 2285 2931 11400 op/s
Update Instance 11214 4652 7777 8277 9629 1357 350 n/a 3873 17071 op/s
Remove Instance 11543 5496 8084 8966 10349 1876 657 n/a 4109 18017 op/s
CUD Average 10158 4658 8046 8375 9136 1742 647 n/a 3540 14866 op/s
Multiple Operations:
Create Instance 19154 4927 7841 19187 26995 5656 21059 n/a 3534 42006 op/s
Update Instance 39415 5428 9804 23676 24936 2060 16435 69089 3849 41714 op/s
Remove Instance 63453 7316 9376 29181 32521 2204 18364 264125 4045 66460 op/s
CUD Average 31830 5698 8887 22923 26899 2642 18429 n/a 3587 47437 op/s
Data Access Performance:
Query:
LINQ Query 7022 552 839 1500 437 750 1109 3587 224 n/a queries/s
Compiled LINQ Query 10585 6049 2352 8106 8827 8619 n/a 3644 n/a n/a queries/s
Native Query 15720 7815 7366 9685 n/a n/a 5281 5504 6864 18131 queries/s
Paging (LINQ only):
Get Small Page (10 items) 8087 4084 2190 5825 6226 6858 887 2727 217 n/a pages/s
Get Average Page (20 items) 9474 3069 2005 4219 5861 7508 794 2379 212 n/a pages/s
Get Large Page (50 items) 7509 1812 1596 2349 3746 6002 560 1759 199 n/a pages/s
Get Huge Page (100 items) 5253 1605 1233 1289 2356 4748 406 1177 175 n/a pages/s
Materialization:
LINQ Materialize 995262 193771 88141 152247 305446 911327 55885 370257 87161 n/a objects/s
Native Materialize 1494678 231747 155967 168218 n/a n/a 66585 401145 99894 2196740 objects/s

Units:
op/s: operations per second, more is better;
queries/s: queries per second, more is better;
pages/s: pages per second, more is better;
objects/s: # of materialized objects per second, more is better.


Performance tests (10000 items):
Pass 1 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 2 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 3 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 4 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 5 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)

Performance tests (10000 items) scorecard:
BLT EF ES DO LC L2S NH OA SS SQL Unit
CRUD Performance:
Fetch 11293 5416 8022 8505 11237 7976 7986 n/a 9273 19637 op/s
Single Operation:
Create Instance 8049 4668 9025 7964 7989 1515 4142 2412 3477 11519 op/s
Update Instance 10607 4793 7991 8720 9909 1025 177 n/a 3749 17523 op/s
Remove Instance 11043 5784 7984 9233 10759 1707 347 n/a 4082 18237 op/s
CUD Average 9706 4985 8305 8607 9368 1350 341 n/a 3750 15083 op/s
Multiple Operations:
Create Instance 19214 5852 9685 13153 22867 5885 18948 n/a 3554 18725 op/s
Update Instance 40428 5736 10182 23787 23886 2066 16260 62129 3855 39451 op/s
Remove Instance 63211 6980 7854 29190 33325 2224 18037 265547 4052 63969 op/s
CUD Average 32209 6141 8965 19672 25929 2716 17639 n/a 3773 31762 op/s
Data Access Performance:
Query:
LINQ Query 7582 566 841 1513 442 763 1119 3562 224 n/a queries/s
Compiled LINQ Query 11129 6213 2441 8567 9194 9166 n/a 3742 n/a n/a queries/s
Native Query 15620 8128 7654 9830 n/a n/a 5378 5525 7290 16734 queries/s
Paging (LINQ only):
Get Small Page (10 items) 8987 4145 2228 5866 6498 7330 893 2651 218 n/a pages/s
Get Average Page (20 items) 7951 3361 2128 4423 5164 6193 795 2348 213 n/a pages/s
Get Large Page (50 items) 7617 2063 1930 2362 2984 6236 577 1941 201 n/a pages/s
Get Huge Page (100 items) 5726 1256 1533 1564 1751 4884 387 1384 183 n/a pages/s
Materialization:
LINQ Materialize 1071868 154959 78078 191532 224288 1033292 55642 237374 100185 n/a objects/s
Native Materialize 1657467 170901 186471 240698 n/a n/a 64102 241198 112464 2458996 objects/s

Units:
op/s: operations per second, more is better;
queries/s: queries per second, more is better;
pages/s: pages per second, more is better;
objects/s: # of materialized objects per second, more is better.


Performance tests (30000 items):
Pass 1 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 2 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 3 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 4 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)
Pass 5 out of 5...
Testing: BLToolkit (BLT)
Testing: ADO.NET Entity Framework (EF)
Testing: EntitySpaces (ES)
Testing: DataObjects.Net (DO)
Testing: Devart LinqConnect (LC)
Testing: LINQ to SQL (L2S)
Testing: NHibernate (NH)
Testing: OpenAccess (OA)
Testing: Subsonic (SS)
Testing: SqlClient (SQL)

Performance tests (30000 items) scorecard:
BLT EF ES DO LC L2S NH OA SS SQL Unit
CRUD Performance:
Fetch 11284 5389 8012 8471 11209 7884 7967 n/a 9359 19817 op/s
Single Operation:
Create Instance 10693 3703 8986 7017 8090 644 4472 2375 3555 12266 op/s
Update Instance 10660 4171 8074 8864 10096 523 58 n/a 3874 16950 op/s
Remove Instance 11310 5678 6845 9325 10700 1230 118 n/a 4067 18430 op/s
CUD Average 10830 4372 7718 8139 9467 700 115 n/a 3812 15233 op/s
Multiple Operations:
Create Instance 29776 5684 9565 20855 24922 5839 20648 n/a 3488 40744 op/s
Update Instance 39208 5524 9974 24086 24008 2030 16304 181068 3624 40242 op/s
Remove Instance 60705 7059 4321 29826 34254 2182 17953 800826 3844 62904 op/s
CUD Average 39583 5965 6857 24308 26670 2663 18110 n/a 3553 45238 op/s
Data Access Performance:
Query:
LINQ Query 7509 553 839 1500 434 746 1106 3578 220 n/a queries/s
Compiled LINQ Query 11672 6373 2636 8453 9216 9204 n/a 3745 n/a n/a queries/s
Native Query 15177 8197 7615 9928 n/a n/a 5427 5640 7396 17395 queries/s
Paging (LINQ only):
Get Small Page (10 items) 9907 4166 2445 6050 6711 7511 899 2669 214 n/a pages/s
Get Average Page (20 items) 8693 3351 2344 4412 5188 6766 780 2405 211 n/a pages/s
Get Large Page (50 items) 6460 2067 2068 2467 3156 5487 558 1959 199 n/a pages/s
Get Huge Page (100 items) 4595 1229 1727 1542 1883 4111 379 1488 182 n/a pages/s
Materialization:
LINQ Materialize 1032688 166010 72147 185745 234202 1161678 51123 274782 111068 n/a objects/s
Native Materialize 1774318 177693 163432 224871 n/a n/a 62428 284473 121561 2637362 objects/s

Units:
op/s: operations per second, more is better;
queries/s: queries per second, more is better;
pages/s: pages per second, more is better;
objects/s: # of materialized objects per second, more is better.


Change log

3b03db5f84fa by Alexis Kochetov on Mar 15, 2011   Diff
- Results are updated
Go to: 

Older revisions

871813742969 by Alexis Kochetov on Mar 11, 2011   Diff
- Products are updated to latest
versions
fe4dac55d3cd by Alex Yakunin on Aug 14, 2010   Diff
Uptput.txt is updated (EntitySpaces
tests are fixed now).
830d8be0729f by Alex Yakunin on Aug 4, 2010   Diff
Results are updated again.
All revisions of this file

File info

Size: 37636 bytes, 685 lines
Powered by Google Project Hosting