Using ADO.NET http://en.wikipedia.org/wiki/ADO.NET，从数据库检索数据并将数据填充到我的业务对象中的最快方法是什么？
我应该使用哪一个？DBDataReader , DBDataAdapter，或任何其他课程？
有没有办法让这个过程自动化？假设基于属性名称并将其与数据库字段名称相匹配？
这听起来和 ORM 或微型 ORM 的作用一模一样。这是输出短小精悍的点网 http://code.google.com/p/dapper-dot-net/'s 性能测试 http://code.google.com/p/dapper-dot-net/source/browse/Tests/PerformanceTests.cs（大约 1 分钟前运行，在一台也忙于进行一些转码的 PC 上运行，因此不是 100% 可靠 - 请自行运行）...这也是一个非常有限的测试 - 一如既往，测试应该代表您的特定环境- 但既然我们不能predict您的环境，我们用我们的环境代替！我已将“精致”的标记为<==== dapper
Running 500 iterations that load up a post entity
Mapper Query (non-buffered) took 57ms <==== dapper
hand coded took 57ms
Dynamic Mapper Query (buffered) took 58ms <==== dapper
PetaPoco (Fast) took 58ms
Dynamic Mapper Query (non-buffered) took 59ms <==== dapper
Mapper Query (buffered) took 60ms <==== dapper
Dapper.Cotrib took 60ms <==== dapper
PetaPoco (Normal) took 66ms
Dynamic Massive ORM Query took 67ms
BLToolkit took 88ms
Simple.Data took 96ms
Linq 2 SQL Compiled took 99ms
NHibernate Session.Get took 127ms
SubSonic Coding Horror took 128ms
Entity framework CompiledQuery took 130ms
NHibernate HQL took 132ms
NHibernate SQL took 134ms
NHibernate Criteria took 173ms
Soma took 184ms
Linq 2 SQL ExecuteQuery took 230ms
Linq 2 SQL took 694ms
NHibernate LINQ took 700ms
Entity framework ESQL took 730ms
Entity framework ExecuteStoreQuery took 735ms
Entity framework took 991ms
Entity framework No Tracking took 1011ms
SubSonic ActiveRecord.SingleOrDefault took 4345ms
(end of tests; press any key)
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
