Logo 
Search:

Asp.net Answers

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds
  Question Asked By: Loretta Carpenter   on Aug 19 In Asp.net Category.

  
Question Answered By: Bian Nguyen   on Aug 19

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

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on GetRows of ADO in ADO.Net Or get search suggestion and latest updates.


Tagged: