DataSourceWizardOptionBuilder.EnableCustomSql(Boolean) Method

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

Namespace: DevExpress.DashboardAspNetCore

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

Declaration

C#

public DataSourceWizardOptionBuilder EnableCustomSql(
    bool enableCustomSql
)

VB.NET

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.