To add a reference to the SQL Anywhere .NET Data Provider in a Visual Studio project

1. Start Visual Studio and open your project.

2. In the Solution Explorer window, right-click References and choose Add Reference from the popup menu.

   The Add Reference window appears.

3. On the .NET tab, click Browse to locate iAnywhere.Data.SQLAnywhere.dll. Note that there are separate versions of the DLL for each of Windows and Windows Mobile platforms.

   • For the Windows SQL Anywhere .NET Data Provider, the default location is install-dir\Assembly\v2.
   • For the Windows Mobile SQL Anywhere .NET Data Provider, the default location is install-dir\ce\Assembly\v2.

4. Select the DLL and then click Open.

   For a complete list of installed DLLs, see SQL Anywhere .NET Data Provider required files.

5. You can verify that the DLL is added to your project. Open the Add Reference window and then click the .NET tab. iAnywhere.Data.SQLAnywhere.dll appears in the Selected Components list. Click OK to close the window.

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

To facilitate the use of Data Provider namespace in your code

1. Start Visual Studio and open your project.

2. 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 project:

     using iAnywhere.Data.SQLAnywhere;

   • If you are using Visual Basic, add the following line at the beginning of your project before the line Public Class Form1:

     Imports iAnywhere.Data.SQLAnywhere