ADO.NET Provider for Excel Services

Build 20.0.7587

Using DbProviderFactory

The CData ADO.NET Provider for Excel Services implements the ExcelServicesProviderFactory class to enable you to write generic data access code to Excel Services through the ADO.NET base classes.

Creating Data Access Objects with ExcelServicesProviderFactory

The following sections show how to use the ExcelServicesProviderFactory class to create objects like ExcelServicesConnection, ExcelServicesCommand, and ExcelServicesDataAdapter in a generic way.

Register and Configure DbConnections

Register the provider to the configuration context and define the DbProviderFactory and DbConnection objects. See Creating DbConnections for a guide.

Querying Using DbCommands

Executing DbCommands describes how to use an existing DbProviderFactory and DbConnection object to execute queries to Excel Services.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587