Using the SQL Anywhere Explorer in UltraLite projects

In Visual Studio, you can use the SQL Anywhere Explorer to create connections to UltraLite databases. Once you connect to a database, you can:

  • browse tables and table data

  • design programs to open connections with the UltraLite 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.

Installation note

If you install UltraLite 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 UltraLite, or install a new version of Visual Studio, the process to integrate UltraLite 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\UltraLite\UltraLite.NET\Assembly\v2\installULNet.exe.


Working with UltraLite database connections in Visual Studio
Configuring the SQL Anywhere Explorer
Adding UltraLite database objects using the SQL Anywhere Explorer
Working with UltraLite tables using the SQL Anywhere Explorer