SqlWizardOptions Enum

Lists the options available to customize the SQL pages of the Data Source Wizard.

Namespace: DevExpress.DataAccess.Wizard

Assembly: DevExpress.DataAccess.v20.1.dll

Declaration

[Flags]
public enum SqlWizardOptions
<Flags>
Public Enum SqlWizardOptions

Members

Name Description
None

Applies the default settings to the SQL Data Source Wizard.

DisableNewConnections

Prevents a user from specifying the connection parameters manually, so that it is only possible for a user to select from the predefined set of parameters.

EnableCustomSql

Enables a user to specify a custom SQL string in the Query Builder.

QueryBuilderLight

Disables the capability to specify custom SQL queries, column aliases and expressions. Instead, this option enables the use of custom names for tables and columns that are supplied by the IDisplayNameProvider interface.

QueryBuilderTreeListView

Enables a table-like interface for selecting fields in the Query Builder (instead of a diagram-based control).

LegacyExpressionEditor

Enables a user to switch to an older version of the Expression Editor that does not support intelligent code completion.

MultiQueryWizard

Enables a user to switch to a newer Data Source Wizard version that enables creating multiple queries (along with defining master-detail relationships between them) with a single run of the wizard.

LegacyMasterDetailEditor

Enables a user to switch to an older version of the Master-Detail Relation Editor that does not provide a diagram-based control where relationships are defined using drag-and-drop.

LegacyUI

Enables a user to switch to an older version of the Expression Editor that does not support intelligent code completion, as well as enable a table-like interface for selecting fields in the Query Builder (instead of a diagram-based control).

Related API Members

The following properties accept/return SqlWizardOptions values:

Library Related API Members
Cross-Platform Class Library ConfigureConnectionContext.Options
EditQueryContext.Options
WinForms Controls ConfigureConnectionContext.Options
EditQueryContext.Options

Remarks

For security reasons, it is not recommended to simultaneously enable the EnableCustomSql and QueryBuilderLight options.

For a code sample, see the following example online: How to switch the Report Wizard back to a single-query version.

See Also