DataSourceWizardOptionBuilder.EnableCustomSql(Boolean) Method

Enables a user to specify a custom SQL string in the Data Source wizard.

Namespace : DevExpress.DashboardAspNetCore

Assembly : DevExpress.Dashboard.v25.2.AspNetCore.dll

NuGet Package : DevExpress.AspNetCore.Dashboard

Declaration

C#
VB.NET

csharp

public DataSourceWizardOptionBuilder EnableCustomSql(
    bool enableCustomSql
)

Public Function EnableCustomSql(
    enableCustomSql As Boolean
) As DataSourceWizardOptionBuilder

Parameters

Name	Type	Description
enableCustomSql	Boolean

true , to allow a user to specify a custom SQL string in the Data Source wizard; otherwise, false.

Returns

Type	Description
DataSourceWizardOptionBuilder

A reference to this instance after the operation has completed.

Remarks

Executing custom SQL queries is forbidden by default. Use the AllowExecutingCustomSql property to allow the Web Dashboard to execute SQL queries on the server side.

Warning

The use of custom SQL queries can lead to inadvertent or unauthorized modifications to your data/database structure. Ensure that you follow best practices and implement the appropriate user read/write privileges at database level.