It is 6-8 faster than ADO in real world.
I disagree it's harder in ADO.net once you grasp which of the 3 tools you use to fetch:
=> ExecuteScalar www.learnasp.com/freebook/learn/executescalar.aspx
=> DataReader www.learnasp.com/freebook/learn/datareader.aspx
=> DataTable www.learnasp.com/freebook/learn/datatable.aspx
Plus Datasets generally can accomplish task recordsets did with a fraction of the code
http://www.learnasp.com/learn/datasets.aspx
ADO.net however has really bad documentation and the web samples continue that tradition.
ADO.net Core Reference
www.amazon.com/.../learnasp
is a great book that will show you the correct way to do everything in an understandable way.
If you want to see the kind of easy things that can be built on top of ADO.net Utility Belt is a good example of taking ADO.net and streamlining it and cutting 80% of code out see:
www.learnasp.com/.../...belt_search_sqlclient.aspx
for example. Given the way Classic ASP works I don't think I ever would create anything of the depth of UtiltyBelt. Too much work. But ADO.net is such a pleasure and so durn fast, I really enjoyed writing it particualrly the elegant way caching could be don thanks to many powerful ASP.net features see:
www.learnasp.com/.../...belt_cached_sqlclient.aspx