Using the .NET Data Provider in a Visual Studio Project

Use the SAP Sybase IQ .NET Data Provider to develop .NET applications with Visual Studio by including both a reference to the SAP Sybase IQ .NET Data Provider, and a line in your source code referencing the SAP Sybase IQ .NET Data Provider classes.

Prerequisites

There are no prerequisites for this task.

Task
  1. Start Visual Studio and open your project.
  2. In the Solution Explorer window, right-click References and click Add Reference.

    The reference indicates which provider to include and locates the code for the SAP Sybase IQ .NET Data Provider.

  3. Click the .NET tab, and scroll through the list to locate any of the following:
    • iAnywhere.Data.SQLAnywhere for .NET 2
    • iAnywhere.Data.SQLAnywhere for .NET 3.5
    • iAnywhere.Data.SQLAnywhere for .NET 4
  4. Click the desired provider and then click OK.

    The provider is added to the References folder in the Solution Explorer window of your project.

  5. Specify a directive to your source code to assist with the use of the SAP Sybase IQ .NET Data Provider namespace and the defined types.

    Add the following line to your project:

    • If you are using C#, add the following line to the list of using directives at the beginning of your source code:

      using iAnywhere.Data.SQLAnywhere;
    • If you are using Visual Basic, add the following line at the beginning of source code:

      Imports iAnywhere.Data.SQLAnywhere

The SAP Sybase IQ .NET Data Provider is set up for use with your .NET application.