O'Reilly logo

Essential ADO.NET by Bob Beauchemin

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

8.4. Writing a Data Provider

A more labor-intensive alternative to staying with your custom OLE DB provider is to write a new data source-specific .NET data provider. In addition to the generic data providers for OLE DB and ODBC, Microsoft has written two data providers (SqlClient and SqlXml) for SQL Server. Microsoft is currently working on custom data providers for Oracle, and DataDirect Technologies has announced data providers for Oracle and Sybase, with perhaps more to come. Although no “standard” is set in stone for .NET data providers, enough information is available for third parties to begin building their own.

The .NET SDK documentation includes details on how to build a data provider, what types and interfaces make up a standard provider, ...

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