ADODB v System.Data.SqlClient

[Slim]

What are the pros and cons of using ADODB in ASP.NET v System.Data
namespace?

I not refereeing to supplying data to controls but for manipulating with
code.

I prefer to use ADODB, but is there any performance benifits from using
System.Data namespace?

thanks

 

[Kevin Spencer]

I prefer to use ADODB, but is there any performance benifits from using

System.Data namespace?

Many. ADODB is COM, while .Net is .Net. They are not compatible. To use
ADODB in .Net you must employ COM interop, which is dangerous at best, and
expensive in terms of resource usage. In short, it *will* slow down your
performance, and it *could* cause unexpected errors.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.