O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The OLE DB .NET Data Provider

ADO.NET includes a .NET data provider designed to communicate with databases using OLE DB providers: the OLE DB .NET Data Provider. I recommend using this .NET data provider only if you’re working with an Office Access database.

If there is a .NET data provider specifically designed for your database, you should use that .NET data provider instead because that provider will most likely outperform the OLE DB .NET Data Provider and offer more database-specific features. Using the OLE DB .NET Data Provider from your .NET code incurs a significant performance penalty because every time the OLE DB .NET Data Provider communicates with your OLE DB provider, it has to go through the COM interop layer.

I’ve been surprised (and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required