Using DbProviderFactory
The CData ADO.NET Provider for Google Sheets implements the GoogleSheetsProviderFactory class to enable you to write generic data access code to Google Sheets through the ADO.NET base classes.
Creating Data Access Objects with GoogleSheetsProviderFactory
The following sections show how to use the GoogleSheetsProviderFactory class to create objects like GoogleSheetsConnection, GoogleSheetsCommand, and GoogleSheetsDataAdapter 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 Google Sheets.