The Visual Studio options dialog 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.
From the Visual Studio Tools menu, choose Options.
The Options dialog appears.
In the left pane of the Options dialog, expand SQL Anywhere.
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.
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 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.
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.