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.
From the Visual Studio Tools menu, choose Options.
In the left pane of the Options window, 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.
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.
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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|