This page outlines the steps that are required to use the Microsoft ADO.NET data provider for CData Connect.

Note: Before you can configure and use ADO.NET with CData Connect, you must first connect a data source to your CData Connect account. See Connections for more information.

Install the Provider

Follow these steps to download and install the provider:

  1. Open the Client Tools page in CData Connect.

  2. In the Dev Tools section, click ADO.NET.

  3. Download and run the setup file.

  4. The installer can automatically detect software that supports ADO.NET, such as Visual Studio. Select the options that you want the installer to configure.

After installation, the ADO.NET Provider will be available in the software that you selected during installation.

Connect to CData Connect

CData Connect uses OAuth to establish a connection between the ADO.NET Provider and your account. The steps below provide an example of configuring the ADO.NET Provider in Visual Studio 2022:

  1. In Visual Studio, click Tools > Connect to Database.

  2. Select CData Connect Data Source as your Data Source.

  3. In the Data Provider drop-down menu, select ADO.NET Provider for CData Connect 2021 and click Continue.

  4. The Add Connection window appears. In the Auth Scheme field, select OAuth. Do not fill out other fields.

  5. Click Test Connection.
    • If you are already logged in, a success message appears.
    • If you are not logged in, the CData Connect sign-in window opens in your web browser. Sign in and return to Visual Studio.
  6. Click OK on the success message and OK in the Add Connection window.

Your connection appears in the Server Explorer pane under the Data Connections section.

Connect to a Workspace

To connect the ADO client to a specific workspace, you specify the workspace name in the Workspace field of the Add Connection window.

Learn More

To learn more information about using the ADO.NET Provider for CData Connect, click here.