In Visual Studio .NET 2003 and 2005, you can use the SQL Anywhere Explorer to create connections to SQL Anywhere databases. Once you connect to a database, you can:
view the tables, views, and procedures in the database
view the data stored in tables and views
design programs to open connections with the SQL Anywhere database, or to retrieve and manipulate data
drag and drop database objects onto C# or Visual Basic code or forms so that the IDE automatically generates code that references the selected object
You can also open Sybase Central and Interactive SQL from Visual Studio .NET by choosing the corresponding command from the Tools menu.
If you install SQL Anywhere software on a Windows computer that already has Visual Studio installed, the installation process detects the presence of Visual Studio and performs the necessary integration steps. If you install Visual Studio after installing SQL Anywhere, or install a new version of Visual Studio, the process to integrate SQL Anywhere with Visual Studio must be performed manually as follows:
Ensure Visual Studio is not running.
For Visual Studio .NET 2003, run install-dir\Assembly\v1\setupVSPackage.exe.
For Visual Studio 2005, run install-dir\Assembly\v2\setupVSPackage.exe.
Working with database connections in Visual Studio .NET
Configuring the SQL Anywhere Explorer
Adding database objects using the SQL Anywhere Explorer
Working with tables using the SQL Anywhere Explorer
Working with procedures and functions using the SQL Anywhere Explorer