In Visual Studio, 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 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 at a command prompt as follows:
Ensure Visual Studio is not running.
At a command prompt, run install-dir\Assembly\v2\SetupVSPackage.exe /install.
Working with database connections in Visual Studio
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
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|