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 ...
Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition 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.
