Back to Devexpress

DataSourceWizardOptionBuilder.EnableCustomSql(Boolean) Method

dashboard-devexpress-dot-dashboardaspnetcore-dot-datasourcewizardoptionbuilder-dot-enablecustomsql-x28-system-dot-boolean-x29.md

latest2.3 KB
Original Source

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

csharp
public DataSourceWizardOptionBuilder EnableCustomSql(
    bool enableCustomSql
)
vb
Public Function EnableCustomSql(
    enableCustomSql As Boolean
) As DataSourceWizardOptionBuilder

Parameters

NameTypeDescription
enableCustomSqlBoolean

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

|

Returns

TypeDescription
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.

See Also

DataSourceWizardOptionBuilder Class

DataSourceWizardOptionBuilder Members

DevExpress.DashboardAspNetCore Namespace