SqlWizardOptions Enum
Lists the options available to customize the SQL pages of the Data Source Wizard.
Namespace: DevExpress.DataAccess.Wizard
Assembly: DevExpress.DataAccess.v20.2.dll
NuGet Packages: DevExpress.DataAccess, DevExpress.WindowsDesktop.DataAccess
Declaration
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.