SQL ADO.NET Objects Versus OleDb ADO.NET Objects

So what is the big difference? And why are there two different components to manipulate data?

The biggest difference is not apparent on the outside. It is inside where the differences are tremendous. If you look at how the two components differ, SQLClient is native to .NET and MS SQL Server. It communicates to SQL using its own protocol. This enables it to work more quickly and to avoid having to ...

Get Debugging ASP.NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.