SqlWizardSettings.QueryBuilderLight Property

Specifies whether or not the Query Builder invoked from the Data Source Wizard provides table and column names’ customization.

Namespace: DevExpress.DataAccess.UI.Wizard

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

[DefaultValue(false)]
public bool QueryBuilderLight { get; set; }

VB.NET

<DefaultValue(False)>
Public Property QueryBuilderLight As Boolean

Property Value

Type	Default	Description
Boolean	false	true, to enable table and column names’ customization; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to QueryBuilderLight
WinForms Controls	DataSourceWizardSettings	.SqlWizardSettings .QueryBuilderLight
Dashboard	DashboardDesignerDataSourceWizardSettings	.SqlWizardSettings .QueryBuilderLight
.NET Reporting Tools	XRDesignMdiController	.SqlWizardSettings .QueryBuilderLight

Remarks

The lightweight Query Builder allows you to specify user-friendly names for tables and columns instead of actual data member names. The IDisplayNameProvider interface provides this functionality. The Light Query Builder does not display the resulting SQL query and disables column expressions because these options use actual data member names. The lightweight version is available for WinForms and WPF.

Query Builder Light Mode for WinForms

Set the QueryBuilderLight property to true to enable the Query Builder Light mode (for instance, in the Form’s Load event handler).

C#

private void Form1_Load(object sender, EventArgs e) {
    //...
    reportDesigner1.DataSourceWizardSettings.SqlWizardSettings.QueryBuilderLight = true;
    //...
}

VB.NET

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs)
    '...
    reportDesigner1.DataSourceWizardSettings.SqlWizardSettings.QueryBuilderLight = True
    '...
End Sub

The following image illustrates the lightweight Query Builder version for Winforms.

Query Builder Light Mode for WPF

Set the QueryBuilderLight property to true to enable the Query Builder Light mode (for instance, in the Window’s Loaded event handler).

C#

private void Window_Loaded(object sender, RoutedEventArgs e) {
    //...
    reportDesigner.DataSourceWizardSettings.SqlWizardSettings.QueryBuilderLight = true;
    //...
}

VB.NET

Private Sub Window_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
    '...
    reportDesigner.DataSourceWizardSettings.SqlWizardSettings.QueryBuilderLight = True
    '...
End Sub

Alternatively, you can use the following XAML code to enable the lightweight Query Builder version.

XAML

<Window ...
        xmlns:dxrud="http://schemas.devexpress.com/winfx/2008/xaml/reports/userdesigner"
        xmlns:dxda="http://schemas.devexpress.com/winfx/2008/xaml/dataaccess">

    <dxrud:ReportDesigner x:Name="reportDesigner">
        <dxrud:ReportDesigner.DataSourceWizardSettings>
            <dxda:DataSourceWizardSettings SqlWizardSettings="{dxda:SqlWizardSettings QueryBuilderLight=True}" />
        </dxrud:ReportDesigner.DataSourceWizardSettings>
    </dxrud:ReportDesigner>
</Window>

This image illustrates the Light Query Builder for WPF.