Working with UltraLite database connections in Visual Studio

Use the SQL Anywhere Explorer to display the UltraLite database connections under the Data Connections node. You must create a data connection to view the data in the tables.

You can list database tables in the SQL Anywhere Explorer and expand individual tables to list their columns. The properties for an object selected in the SQL Anywhere Explorer window appear in the Visual Studio Properties pane.

To add an UltraLite database connection in Visual Studio
  1. Open the SQL Anywhere Explorer by choosing View » SQL Anywhere Explorer.

  2. In the SQL Anywhere Explorer window, right-click Data Connections, and then choose Add Connection.

  3. Select UltraLite, and then click OK.

  4. Enter the appropriate values to connect to your database.

  5. Click OK.

    A connection is made to the database, and the connection is added to the Data Connections list.

To remove an UltraLite database connection from Visual Studio
  1. Open the SQL Anywhere Explorer by choosing View » SQL Anywhere Explorer.

  2. In the SQL Anywhere Explorer window, right-click the UltraLite data connections you want to remove, and then choose Delete.

    The connection is removed from the SQL Anywhere Explorer window.