The Visual Studio Options window includes settings that you can use to configure the SQL Anywhere Explorer. Some of the options are general options and some are specific to UltraLite usage only.

To access SQL Anywhere Explorer options

1. From the Visual Studio Tools menu, choose Options.

2. In the left pane of the Options window, expand SQL Anywhere.

3. Click General to configure the SQL Anywhere Explorer general options as required.

   Limit Query Results Sent To Output Window   Specify the number of rows that appear in the Output window. The default value is 500.

   Show System Objects In Server Explorer   Check this option if you want to see system objects in the Microsoft Server Explorer. This is not a SQL Anywhere Explorer option but a Server Explorer option. System objects include those owned by the "dbo" user.

   Sort Objects   Choose to sort objects in the for UltraLite Explorer window by object name or by object owner name.

   Generate UI Code When Dropping A Table Or View Onto The Designer   Generate the code for tables or views that you drag and drop onto the Windows forms designer.

   Generate Insert, Update, And Delete Commands For Data Adapters   Generate INSERT, UPDATE, and DELETE commands for the data adapter when you drag and drop a table or view onto a C# or Visual Basic document.

   Generate Table Mappings For Data Adapters   Generate table mappings for the data adapter when you drag and drop a table onto a C# or Visual Basic document.

4. Click UltraLite to configure the specific option for UltraLite.

   Generate When Dropping A Table Into Code   Generate code of a specific type for tables that you drag and drop into your application code. Choose from one of the following:

   • ULResultSet represents an editable result set on which you can perform positioned updates and deletes.

   • ULDataReader represents a read-only result set.

   • ULTable represents code that allows you to store, remove, update, and read data from a table.

   • ULDataAdapter gives you a method to work with table data offline.